The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Friday afternoon and SD Stops due to template/roles/NullPointers..

Highlighted
Rikard Ekman
Regular Collector

Friday afternoon and SD Stops due to template/roles/NullPointers..

Hello All,

When Friday is drawing to an e´nd the SD stops!
Great!
The logfile will look like this:
fr, 04/08/2006 13:06:45 Started.
fr, 04/08/2006 13:06:45 Started.
fr, 04/08/2006 13:06:45 Starting agent manager on stoptjhkov02.hk.ptj.se
fr, 04/08/2006 13:06:45 Job queue monitor starting.
fr, 04/08/2006 13:06:45 Starting monitor for failed or expired jobs.
fr, 04/08/2006 13:06:45 Started.
fr, 04/08/2006 13:06:45 Starting multicast listener.
fr, 04/08/2006 13:06:45 Started.
fr, 04/08/2006 13:06:45 Initialized Opta SQL Server JDBC Driver DataSource
fr, 04/08/2006 13:06:45 Initialized Opta SQL Server JDBC Driver DataSource
fr, 04/08/2006 13:06:45 Restart DB Connection Checker
fr, 04/08/2006 13:06:45 Starting Business Layer.
fr, 04/08/2006 13:06:45 Getting system information from database.
fr, 04/08/2006 13:06:45 : [STOPTJHKOV01]Changed database context to 'SDDB'., SQL state: 01000
fr, 04/08/2006 13:06:45 : [STOPTJHKOV01]Changed language setting to us_english., SQL state: 01000
fr, 04/08/2006 13:06:45 Running in single server mode.
fr, 04/08/2006 13:06:50 Systemjava.lang.NullPointerException
at com.hp.ifc.rep.AppItemFolderAccess.getStatusEntityID(Unknown Source)
at com.hp.ifc.rep.AppItemFolderAccess.getStatusFromOrdering(Unknown Source)
at com.hp.ifc.rep.AppItemFolderAccess.merge(Unknown Source)
at com.hp.ifc.rep.AppRoleInfo.merge(Unknown Source)
at com.hp.ifc.bus.AppSrvRepository.loadRoles(Unknown Source)
at com.hp.ifc.bus.AppBusinessManager.getRoleInfo(Unknown Source)
at com.hp.ifc.bus.AppBusinessManager.createSystemSession(Unknown Source)
at com.hp.ifc.bus.AppBusinessManager.bootstrap(Unknown Source)
at com.hp.ifc.bus.AppBusinessManager.(Unknown Source)
at com.hp.ifc.bus.AppServer.startup(Unknown Source)
at com.hp.ifc.bus.AppServer.main(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.hp.startup.Bootstrap.runprogram(Unknown Source)
at com.hp.startup.Bootstrap.main(Unknown Source)

fr, 04/08/2006 13:06:50 End session.
So what has been done:
Well, last time it where restarted it where using the inkluded java 1.3.x (1month ago)
First restart of the day and the server used a 1.4.2 from an installed business objects db.
Well removed all java versions and tried, same result.
Reinstalled the server, same result.
Used the stageingn systems server to connect to the live db, same result.
Conclusion, whaT SEEMED TO BE A JAV RELATED ERROR IS ACTUALLY SOMETHING IN THE DB. (Sorry by the caps, me tired..)

So, what to do, checked the itrc, there is something with sp17 on 4.5 and delayed rolecaching not working, well I realy cant load the db now so...

Have someone found the same problem?

First with the sollution will get...

I presume I will have to try an upgrade to sp18, but it will not be an ideal sollution..

Regards

//Rikard
Computers are evil, destroy them, destroy them all!
10 REPLIES
Rikard Ekman
Regular Collector

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

Added inf:
The only changes that I know abouth in the system where this week.
We addeded some templates and form changes for one role in the system, had problems to access these changes, therefore my mentioning the sp17 problem of delayed role caching..

//R
Computers are evil, destroy them, destroy them all!
Jonathon Druce
Honored Contributor

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

What DBMS are you using (SQL or oracle)? Habe you tried running the DBConfig wizard with the -internal switch and doing a database check?
Rikard Ekman
Regular Collector

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

Yes,

Tried, unfortunatly the internal command is assuming that you have not done anything in the db... Well maybe you shouldn´t, I allways do, there is sooo much you can do...
In this specific case I have not done any magic in the db, but a competing consultant firm have (name not included). Some tables and logic have been added..

Long discution short:
Yes tried, it will finish with errors for the added tables.
It is probably not the added tables though, restarts have been working well, untill last week. When the only changes where:
1. It started up on another java version
2. We had added/changed templates and forms that had been related to one specific role

Regards //Rikard
Computers are evil, destroy them, destroy them all!
Rikard Ekman
Regular Collector

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

Version: MS SQL
//R
Computers are evil, destroy them, destroy them all!
Ashly A K
Honored Contributor

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

hi!!

A strange issue!!!

Well, is there any stored procedures running on Friday ?
Have you tried to roll back all the changes (irrespective of small/big, related/not related )

Wish i could answer you....

-Ashly
http://www.geocities.com/helponhpopenview
Rikard Ekman
Regular Collector

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

Hi Ashly,

Yes, strange indeed....

No stored procedures knowingly that where running friday, that I know about.
Yes tried rolling back, DB backup for DB backup, the last working one where the one done on the system sunday the week before. So our changes in the system during the week crashed/messed the db so bad that the first restart after these changes (friday) could not be done, but the system where working during the week... (except that only administrators could see the changes we had done.)

//R
Computers are evil, destroy them, destroy them all!
Ashly A K
Honored Contributor

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

hi!

01. have you done DBConfig wizard with the -internal ?

02. have you done a DB/UI rule analysis using the bad rule identifier ?

03. Have you tried
a) Set up a test environment
b) On any other day, set the system date time to Friday and see if crashes

04. Put the test system on a different subnet (isolate it from other servers)

05. Down load a different set of Service Pack and apply.

06. Install the application from another set of CD

07. Do you have an active HP support contract ?

I know, some of the stuffs i mentioned doesn't make sense...just a wild try....

http://www.geocities.com/helponhpopenview
Rikard Ekman
Regular Collector

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

Hello,

01. Yes - Different after
02. Yes - No strange unserialized rules
03. a. Yes - It crashed..
03. b. No - Do not think it was the date..
04. Nope, but rechecked that the servers is not sharing data..
05. Yes, tried that, reinstalled the server, but it is the db...
06. No, didn't do that, but the app worked with the stage db, so..
07. Absolutly, do you think HP support has replyed yet? :-)

No problem, all input helps, now we are using an old backup, to make the system run, but it has some major hickups, like not being able to audit values...

//R
Computers are evil, destroy them, destroy them all!
Ashly A K
Honored Contributor

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

Okey....
http://www.geocities.com/helponhpopenview
Rikard Ekman
Regular Collector

Re: Friday afternoon and SD Stops due to template/roles/NullPointers..

No Solution what so ever, but not relevant anymore since we are using another sp and things seems to work ok for the customer...
Computers are evil, destroy them, destroy them all!
//Add this to "OnDomLoad" event