Wednesday, April 21, 2010

Integration Broker - Errors

Schema Validation Tester Error:

Fatal Error: ( line: 0 column: 0 ) An exception occurred! Type:NetAccessorException, Message:Could not open file: http://machname:portno/PSIGW/PeopleSoftServiceListeningConnector?Operation=GetSchema&xsd=KAB_IB_TST_MSG.Version_1Error: ( line: 2 column: 17 ) Unknown element 'KAB_IB_TST_MSG'Error: ( line: 3 column: 15 ) Unknown element 'FieldTypes'Error: ( line: 4 column: 32 ) Unknown element 'KAB_TEST_IB_REC'Error: ( line: 4 column: 32 ) Attribute 'class' is not declared for element 'KAB_TEST_IB_REC'Error: ( line: 5 column: 27 ) Unknown element 'OPRID'Error: ( line: 5 column: 27 ) Attribute 'type' is not declared for element 'OPRID'Error: ( line: 6 column: 33 ) Unknown element 'OPRDEFNDESC'Error: ( line: 6 column: 33 ) Attribute 'type' is not declared for element 'OPRDEFNDESC'Error: ( line: 8 column: 23 ) Unknown element 'PSCAMA'Error: ( line: 8 column: 23 ) Attribute 'class' is not declared for element 'PSCAMA'Error: ( line: 9 column: 33 ) Unknown element 'LANGUAGE_CD'Error: ( line: 9 column: 33 ) Attribute 'type' is not declared for element 'LANGUAGE_CD'Error: ( line: 10 column: 32 ) Unknown element 'AUDIT_ACTN'Error: ( line: 10 column: 32 ) Attribute 'type' is not declared for element 'AUDIT_ACTN'Error: ( line: 11 column: 38 ) Unknown element 'BASE_LANGUAGE_CD'Error: ( line: 11 column: 38 ) Attribute 'type' is not declared for element 'BASE_LANGUAGE_CD'Error: ( line: 12 column: 33 ) Unknown element 'MSG_SEQ_FLG'Error: ( line: 12 column: 33 ) Attribute 'type' is not declared for element 'MSG_SEQ_FLG'Error: ( line: 13 column: 40 ) Unknown element 'PROCESS_INSTANCE'Error: ( line: 13 column: 40 ) Attribute 'type' is not declared for element 'PROCESS_INSTANCE'Error: ( line: 14 column: 37 ) Unknown element 'PUBLISH_RULE_ID'Error: ( line: 14 column: 37 ) Attribute 'type' is not declared for element 'PUBLISH_RULE_ID'Error: ( line: 15 column: 33 ) Unknown element 'MSGNODENAME'Error: ( line: 15 column: 33 ) Attribute 'type' is not declared for element 'MSGNODENAME'Error: ( line: 18 column: 12 ) Unknown element 'MsgData'Error: ( line: 19 column: 18 ) Unknown element 'Transaction'Error: ( line: 20 column: 34 ) Unknown element 'KAB_TEST_IB_REC'Error: ( line: 20 column: 34 ) Attribute 'class' is not declared for element 'KAB_TEST_IB_REC'Error: ( line: 21 column: 30 ) Unknown element 'OPRID'Error: ( line: 21 column: 30 ) Attribute 'IsChanged' is not declared for element 'OPRID'Error: ( line: 22 column: 36 ) Unknown element 'OPRDEFNDESC'Error: ( line: 22 column: 36 ) Attribute 'IsChanged' is not declared for element 'OPRDEFNDESC'Error: ( line: 24 column: 25 ) Unknown element 'PSCAMA'Error: ( line: 24 column: 25 ) Attribute 'class' is not declared for element 'PSCAMA'Error: ( line: 25 column: 22 ) Unknown element 'LANGUAGE_CD'Error: ( line: 26 column: 21 ) Unknown element 'AUDIT_ACTN'Error: ( line: 27 column: 27 ) Unknown element 'BASE_LANGUAGE_CD'Error: ( line: 28 column: 23 ) Unknown element 'MSG_SEQ_FLG'Error: ( line: 29 column: 27 ) Unknown element 'PROCESS_INSTANCE'Error: ( line: 30 column: 27 ) Unknown element 'PUBLISH_RULE_ID'Error: ( line: 31 column: 23 ) Unknown element 'MSGNODENAME'

1) Copy the url in to the address bar of the browser:
http://machine:portno/PSIGW/PeopleSoftServiceListeningConnector?Operation=GetSchema&xsd=KAB_IB_TST_MSG.Version_1

2) Got the following error:


-
-
-
SOAP-ENV:Server
null
-
-
Integration Broker Response
20
505
-
-








3) Solution:
Check if GETROUTINGS Service Operation is Active.

GETROUTINGS Service Operation was not Active.

4) Copy the url in to the address bar of the browser:
http://machname:portno/PSIGW/PeopleSoftServiceListeningConnector?Operation=GetSchema&xsd=KAB_IB_TST_MSG.Version_1

Result: Should be able to view the XSD.

-----------------------------------------------------------------
Deadlock Exception
Msg: Exception message: ORA-00060: deadlock detected while waiting for resource
Solution:
Resubmit all the failed messages and clear the integration broker. The failed messages should be resubmitted one at a time to resolve the deadlock issue.

Wednesday, April 7, 2010

PeopleSoft Compare Reports in HTML, XML and Excel

Compare Reports in HTML and Excel

1. Run ‘regedit.exe’.
2. Navigate to HKEY_CURRENT_USER\Software\PeopleSoft\PeopleTools\Release8.40\PSIDE
3. Edit UpgHTMLOutput/UpgXMLOutput and change the value data from 0 to 1 to view it in HTML/XML.
4. Create the new DWORD entry UpgTextOutput and enter the DWORD value as 1 to view it in Excel.