Hi friends,

I am facing a sever problem. When I try to print any report, the select device session (ttstpsplopen) is not started. Print report session looks busy for long time and never comes end, no error message.

What could be the reason?

Thanks in advance
MRF

Look at this thread also - http://www.baanboard.com/baanboard/showthread.php?t=9686&highlight=ttstpsplopen
Run a session with debug flags to peek at what may be happening and/or have it checked with Baan.

Hi victor_cleto,

I compiled the session with the Debug, and got that the session stucked at the statement

report.opened = tccom.dll0010.open.report(1,"",1)

Its never returns. what could be the reason?

Thanks in advnace
MRF

Think the problem is user specific . The user should exist in ttaad2100m000.

I remember having problem to open ttstpspooloen when user is defined only at the directory level.

HI Hitesh Shah,

We dont have the session ttaad2100m000, I think it is the User management session in Baan IV. Well, I checked the user in the corresponding session in Baan V and user is existed. I tried with the supper user "baan", but not able to print any report.

I remember having problem to open ttstpspooloen when user is defined only at the directory level

I dont understand the above statment, could you please expalin a bit more.

Thanks in advance
MRF

In rare cases , user may not exist in user management but u file may exist in lib folder . In such case baan works but printing does not work .

Thought this may be the case in ur case.

Hi Hitesh Shah,

I have checked in the user management session and user is existed. I tried to create the runtime DD for the user but its not continue because it try to open the ttstpsplopen session. Yes, I copied the user files in lib folder from the backup.

Ok, if we assume that the u file is exists in lib folder becasue I copied it from the backup, then how should I proceed to fix this problem, becasue I am not able to create the runtim DD.

Thanks in advance
MRF

MRF,

Based on your recent threads about clone environment, I can suggest you to check the File Access Permissions of the whole BaaN setup, document what you are doing, and improvise on it.

Check the directory permissions of $BSE/tools and $BSE/tmp they should have bsp owner and group write permissions.

Hi,

Your disk might be full where application is installed.


Regards
Sanjay

HI friends,

kathuria: No, disk is not full, there more then 4 GB space available.

NPRao: I have checked the permission on the directories $BSE/tools and $BSE/tmp , and permissions are ok, everyone has full control and Administrator is Owner as same as on the Live server.

Is there any way that we can create a new user and test if the new user can able to do printing. Problem is to create runtime DD for user, the session ttstpsplopen is not starting.

I will appriciate all suggestions to resolve this problem, it is sever problem.

Thanks in advance
MRF

HI friends,

I debugged the report printing session and found that the problem is actually occurs at the following statement


tccom.dll0010.report_id(i.report.number, i.curr.language)
= brp.open.language(spool.report, chr$(i.curr.language), i.sp.device,i.open.mode)


in method "tccom.dll0010.open.report". The program execution stucked at this statement.

I appricaite all suggestions to resolve this problem.

Thanks in advance
MRF

Hi friends,

Let me tell one more thing, I have relocated that Baan environment from windows NT to windows 2000. Here is the detail (http://www.baanboard.com/baanboard/showthread.php?t=23822)

Any idea if the relocating the Baan from NT to 2000 is the reason of problem, how can resolve it?

I will appriciate and will thankful for all suggestions to resolve this problem.

Thanks in advance
MRF

Hi MRF,
don't know if this helps, but i had a similar problem almost a year ago after installing a new solution for ttstpsplopen which was corrupt. The session did not start and i could not install any other Solution.
It was a problem of Runtime Data (table ttadv999).
There i had to change the record for ttstpsplopen (advised by Baan Support) because it contained a wrong value in the field ttadv999.desc.
Here is the value in our environement:
'0ottstpsplopen |C0|ttaad306|21|1||01ttstpsplopend......'
The problem was that after the first pipe there was an entry like M0(or N or P, i can not remember) which i had to change to C0.
This fixed the problem.
Maybe you can check your value.
Hope this helps,
Andreas

HI Andreas,

I have checked the entry in table, the value is same as you mentioned. I think this is not the problem because on the Live server there is no such problem, and this new test server is clone of the Live server. All applicaiton objects and data is copied from the Live server. I think the problem is somewhere else but very little.

Appriciate all suggestions to resolve this problem.

Thanks in advance
MRF

HI Andreas,

I have checked the entry in table, the value is same as you mentioned. I think this is not the problem because on the Live server there is no such problem, and this new test server is clone of the Live server. All applicaiton objects and data is copied from the Live server. I think the problem is somewhere else but very little.

Appriciate all suggestions to resolve this problem.

Thanks in advance
MRF

Are $BSE/lib/dtopt* the same on clone as on live?

Jos

Hi firends,

jodijk: I checked the files $BSE/lib/dtopt* and compared with the Live server, these are same. Also copied them from the Live server and try again, but problem not resolved.

Waiting for further suggestions.

Thanks in advance
MRF

Just a thought - a couple of months ago ttdsk2080m000(Run program) stopped working in our test environment. Baan found that one of our company 000 tables was missing a row (ttadv211). You might want to check ttadv200, ttadv211(etc.) to make sure they match the company 000 in your production environment for this session.

MRF , Were u able to convert users to DD. Is it that when converting users too it opens a report. In Baan IV it's not the case.

HI friends,

Mark: I checked records in tables ttadv200 and ttadv201, it seems that records are same.

Hitesh Shah: Yes, I am not able to convert users to DD becasue in in Baan V this open a report and get stuck at select device session. Is there any way that we can create the DD for user and bypass this select device session? becasue, I think it will help.

Thanks
MRF