I wish to be able to access tables in an SQLServer database to update XA files using a System-Link connection in an RPG program.
I have configured the application for the correct drivers as per various KnowledgeBase documents. We are using IBMi 7.1. The SQL Server driver installed, sqljdbc4.jar, was downloaded from the Microsoft site and installed in the /Infor/driverlib directory in the IFS. This was copied to the PC, as described in the KB used, when first attempting to use the created Data Source.
I have been able to create Business Objects for the tables I need to access, and to populate Views and Cards with the data through Power-Link. I imagine that this uses the same connection dialogue as would System-Link.
I then attempted to access one of the tables through System-Link.
I obtained the XML statement to Query one of the SQLServer tables using the "Navigation/System-Link Request" function from the General View of the business object in Power-Link. But when trying to execute the query, the System-Link session is initiated correctly, and when the QueryObject XML statement is executed through the PSVPSR1R program, the message returned provides the full metadata statements, followed by "
Exception name="com.pjx.eScript.InternalException">
<Text>A system error has occurred</Text>
<Message type="error">
<Text>Please contact your system administrator</Text>
<DetailedText>Session UID: '2b2e8862:153c573385d:-7d5d', Workspace UID: '2b2e8862:153c573385d:-7d5c'</DetailedText>
</Message>
</Exception>
I have sent as many log files as could be found, according to KBs read, to Infor and await a response.
In the meantime, I thought I would place this issue on the MAPICS-L discussion group wondering if anyone has experienced a similar situation and has been able to get around the problem correctly.
Regards,
Alan McKenzie
XA Consultant
[cid:image001.png@01CF39EB.2A7AEA70]
Registration Number: 1967/005978/07
Office: +27 12 381 1405 | Switchboard: +27 12 381 1400
Mobile: +27 (0) 82 453 7990
E-mail: AMcKenzie@xxxxxxxxxxx<mailto:AMcKenzie@xxxxxxxxxxx>
NOTE:- This e-mail message and all attachments hereto contain confidential information intended for specific addressee and purpose. If you are not the addressee:
(a) You may not disclose, copy, distribute or take any action based on the contents hereof.
(b) Kindly inform the sender immediately and destroy all copies thereof.
(c) Any discloser, copying, distribution or any action taken or omitted in reliance on it, is prohibited and may be unlawful.
The views and opinions expressed in this e-mail message may not necessarily be those of the management of the company.
Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
This email has been scanned for viruses and malware, and automatically archived by Mimecast SA (Pty) Ltd, an innovator in Software as a Service (SaaS) for business. Mimecast Unified Email Management (UEM) offers email continuity, security, archiving and compliance with all current legislation. To find out more, visit
http://www.mimecast.co.za/uem.
midrange.com
