Thread: Migrating GS 4.0.1

Hello,

I customized a Get-Sevices 4.0.1 running on a WebLogic server. On my Test system everything is working fine but today I tried to migrate the
customizations to an Acceptance environment (also WebLogic). Here I can not view the details of a Incident. The application is running for a very long time and then returns nothing or is generating an error. However, I can view the details of Calls, search for Calls or Incidents, lists are builded
correctly, etc.
I've tested the this on my Development system (typical installation on
Windows NT, Apache-Tomcat) where I once pointed Get-Services to the Test ServiceCenter server and once to the Acceptance Servicecenter server by changing the settings in the Administration page. This results in the same behavior. So I think there is something wrong on the ServiceCenter side. I loaded all the unl files for GS, copied the giComponentsuser table to the SC server, etc. In archway.log I find the error message " Unable to load schema relatedproblem - no backend provided" but why I don't get the same error in the other log? It is coming from the same GS server, only the SC server is different. Can the number of Incidents/Call have to do something with it? Acceptance contains about 42000 probsummary records as Test only contains about 1600 records.
I included the archway logs for both environments.

This is what I noticed after a few tests.
1) I deleted a lot of records in the tables incidents, probsummary (+- 5600 records left instead of the original 42000) and screlation. Result: everything works fine again. Incidents can be opened again. Speed is not great but acceptable.
2) I suspected the screlation file to be the culprit (Viewing Details on Calls is OK, but Details on Incidents are not) . So I removed the records that describe the relation between Incidents --> Calls. Result: Incidents can be opened and the speed is blazing fast.
3) Edited the problem.xml file in incidentmgt and remarked the part for the collection RelatedCalls (and removed the output to the screen) and put back the 42000 records with their relations. Result: Never seen Get-Services so fast.
Conclusion: Somewhere there is a slow query when looking up the related records of an incident? But I can't find where it's going wrong.

Answer of PRGN: "it must be an implementation issue" but I already reported the slow performance on this when I started with the implementation before I made some major changes. And of course I hadn't so much data in my test environment.

Have a nice day,
Geert

New in get.it version 4 is the possiblity to work with the related records.

Look in the schema definitions for calls/incidents and the pre/post schema scripts .

I guess you will find a couple of non keyed queries using screlation.

Remember that the order of fields in your WHERE statements does matter when you are using P4.