Hi all

When I run the above session for certain projects, I am getting blank error message and the project is not archived.
Project status remains Closed.


Has anyone faced this issue before?
With only blank in error message, we cannot find out what is stopping this project from being archived.

Please advise

thanks n regards,

Hello,

Can anyone answer this issue ?
Please advise

thanks n regards

We never archived anything, but once when we wanted to delete a newly created project(wrong project number or something) - I used print references to parent. Then I could check the other tables. You might be able to use this to check all other tables to see what might be preventing the project from being archived. Maybe something is open still (PO, work order, invoice) that the archiving session does not report. That would be my best swag at how to find the issue.

Hello,
maybe tracing your bshell will give you answers.

Regards

Hello,
avoid double posting in different forums please.

http://www.baanboard.com/baanboard/showthread.php?t=72043

Regards

I did not catch that earlier. I have deleted the other thread. If you think this post will get more hits in one of the other forums - just let a moderator know and they can move it for you.

And sometimes you just have to wait until someone visits that might have encountered your error.

Hello Mark

How do I print References to Parent?

thanks n regards

How do I print References to Parent?

ttaad4229m000

Regards

How do we find the corresponding table to check with this session

Any other suggestions to help resolve the issue

thanks n regards

Hi.

You could have a look at the database commands. To do so:

1. Ensure that you start Baan only once with a specific user.
2. Start the Baan session, fill out all fields, but do not press continue.
3. Get the process id of you bshell, e.g. ps -lu <your user> | grep bshell
4. run bshcmd6.1 -d <options> <pid of your bshell>

options:
0000001: logs data dictionary information of tables within the database driver
0000002: query information (SQL level 1)
0000004: query execution plan (SQL level 2)
0000010: row action information
0000020: table action information
0000040: transaction information
0000100: DBMS input/output data (SQL level 2)
0000200: Administration file information (SQL drivers)
0000400: DBMS SQL statements
0001000: general debug statements
0002000: query processing information
0004000: data buffering information (communication)

I thinks that 0000400 is a good one.

5. Now press continue and let the Baan session do the stuff.
6. Parallel: Watch the logging output, normally in $BSE/tmp/bshell.<your bshell pid>.

I haven't done this for a long time, hope it still works.

Regards
Günther

Hi Gunther

Thanks for your reply

I followed your instructions but the result in the file is very short

i telnet in using bsp
and typed
bshcmd6.1 -d 0000400 16567

Then i went to /baan/bse/tmp and typed
more bshell.16567

The result is
Command 3 (arg '0000400') issued by user bsp.

This is all
What did I do wrong

thanks n regards

Hi,

instead of "more <file>" I would use "tail -f <file>". This will display new data with minimal delay.

You could try different settings (my examples: I'm in ttadv2100m000 "Maintain Sessions" an play with new/prev set buttons):

* bshcmd6.1 -T TT_SQL_TRACE=040<pid>
...
---- TT_SQL_TRACE set to 040
Evaluated Query (QID : 32)
SELECT ttadv200.*, ttaad200.* FROM ttadv200, ttaad200 WHERE ttadv200._index1 BETWEEN { :ttadv200.cpac} AND { :ttadv200.cpac, :ttadv200.cmod, :ttadv200.cses, :ttadv200.vers, :ttadv200.rele, :ttadv200.cust} AND ttadv200.user REFERS TO ttaad200 ORDER BY ttadv200._index1 desc
...

* bshcmd6.1 -T TT_SQL_TRACE=02000<pid>
...
[SqlParse: after parse (e = 0)] SqlId : 4031f808 - QID : 18 - Status : 2
[SqlWhereBind for curr.pacc$] SqlId : 4031f808 - QID : 18 - Status : 2
Value(str): 'B4Cc4lwe'
[SqlExec before exec: (CompNr 000)] SqlId : 4031f808 - QID : 18 - Status : 2
[SqlExec after exec: (CompNr 000)] SqlId : 4031f808 - QID : 18 - Status : 3
[SqlFetch before fetch] SqlId : 4031f808 - QID : 18 - Status : 3
[SqlFetch returns 0 errno 0 msg ] SqlId : 4031f808 - QID : 18 - Status : 4
'nt' 'l108' 'l108' 'c4' 'B40U' 'B4Cc4lwe' 'c4' 'B40U' 0
[SqlFetch after fetch] SqlId : 4031f808 - QID : 18 - Status : 4
[SqlFetch before fetch] SqlId : 4031f808 - QID : 18 - Status : 4
[SqlFetch returns 1 errno 0 msg ] SqlId : 4031f808 - QID : 18 - Status : 4
[SqlFetch after fetch] SqlId : 4031f808 - QID : 18 - Status : 4
[SqlBreak] SqlId : 4031f808 - QID : 18 - Status : 4
[SqlParse: before parse] SqlId : 40320808 - QID : 19 - Status : 0
Trans 1 (bshell(main)) Mode 0 Query:
select ttadv239.cprs
from ttadv239
where ttadv239._index1 = {"nt", "int", "tt-bois"}
and ttadv239._compnr = 0
as set with 1 rows
...

Regards
Günther

Hi experts

I am still unable to find the reason why the session tipcs2260m000 is not archiving some of my projects.
There is no result when I tried to use bshcmd6.1

Anyone has any ideas how to troubleshoot and help find the reason for Archive Project failure?

thanks n regards

Are there any log messages or report messages or is it just not archiving the project? My first thought is it is not arching because something is still open. I thought when we tested in 4c4 on a&d projects it told us the first issue it ran into. But that was too many years ago.

Hi Mark , anyone out there

I am still unsuccessful to archive some projects.
There is no Error shown in the resulting report.

If there is an error msg, I am sure I am able to solve it.
But there is no errors given.
Can someone please help suggest any solution/troubleshooting that I can do to find out why certain projects cannot be archived.

Appreciate any suggestions or solutions

thanks n regards

Have you also checked all of the log files? See if something comes out there. To me there has to be something still open on the project - what I am not exactly sure how to tell.

Hi Mark
Where are the log files? i checked bshell.<pid> and there is nothing there

thanks n regards

The log files located in $BSE/log.

Hi Mark

I do not see any log in the log.bshell file or any other files

Any other way to troubleshoot?
I wonder why there is no errors in the report

thanks n regards

I wonder the same thing also. If you own source code you could try debugging it. If not I would log a case with infor - I am sure they could provide some information or queries on how to locate what might still be open. In our 20 years or so of usage we never did run the archiving processes.

Hi Mark
Do you have any other suggestions?

I do not see the log files in my system.

Appreciate if anyone can help me solve this issue.

thanks n regards

No other suggestion but to log a case with infor. Maybe they can point you to something that you can run to find out what not yet be completed on the project.