on 11-10-2015 1:25 PM
Hi Folks - We use SMP 3.0 SP04 PL2 on Windows 2008. We have one Agentry WM app deployed. This app connects to an ERP backend system.
Recently a change was made to a custom include in the QMEL table in ERP (a new date field was added). Apparently our WM app uses QMEL.
After the change was activated the Agentry app started having issues. This seems normal to me. BUT - we had to restart the Windows server to clear the issue (SMP restart did not work).
Possibly the table definition is cached somewhere in Java?
Has anyone else seen this scenario? Is there some other way to "adjust" the table definition in SMP?
Best Regards - Jeff
Hi Jeff - we have encountered exactly the same issue - if you change the structure of the tables in SAP a restart of the SMP service is sometimes required to reload the definitions. Remember the QMEL extensions are normally done in a customer include CI_QMEL which sits in the middle of the table and not naturally at the end as a normal append structure would - so this requires a restart of the SMP service.
Thanks
Stu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
did you check the agentry logs? what is the message in events logs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Shivkumar for your reply.
In this case there were no SMP-related errors in the logs. The developer was able to determine that the application was still using the old table definition. This resulted in a data mapping issue in the app. Because of the mapping error, the data failed business edits and the user received an error message from the app regarding invalid data.
It seems logical to me that the SMP app would need to get the updated QMEL table layout. I am asking how best to do this when a change is made to a backend table that is used by SMP.
Best Regards - Jeff
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.