• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Promoting a copied Processing Option object

stu

Active Member
I have copied a JDE report, along with selecting the option to copy the related processing option object. This worked fine. My issue is when I attempt to promote these objects from one environment to the next (DV to PY). The report and it's versions get promoted fine, but when it hits the PO object - the process stops and fails. I get the message "Error: Commit or Rollback Failure". If I remove the PO object, the project promotes fine - but it does not with the object. Any ideas?

I am working with Xe - SP 16.1

Thanks
 

Zoltan_Gyimesi

Legendary Poster
Hi "srdeprez",

First of all you are welcome aboard!

Have you checked the Logging/Log Details/Full texts after the promotion as well for the project as for the PO template object too in OMW?
Have you seen any strange in the jde.log?
Have you switched on debug-log an examined it?

Please, let us know what have you seen in the mentioned logs. Maybe you have to try the promotion with a new project to reproduce the logs.

Regards,
Zoltán
P.S.: I suppose that you have already revised your OMW configurations, settings like Activity Rules, User Role and Allowed Actions mainly for DSTR object type, effected statuses and user roles.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

mtrottier

Well Known Member
Question.
Do you have two environments both pointing to the same path code but each environment is using a separate versions list table - F983051?

There is a known issue with the above setup. Please see SAR# 5350026

Mike Trottier
Independent CNC Consultant
Onsite and Dial-up Support
B731,B732,B733,XE
AS400,Unix,NT
Oracle,SQL
#801 557-8368
 

stu

Active Member
I tested this again and got the following in the JDE.LOG file:

(start of jde.log)

329/319 Thu Nov 01 15:26:58 2001 JDBODBC.C2026
ODB0000183 - SQLExecute failed

329/319 Thu Nov 01 15:26:58 2001 JDBODBC.C2026
[Microsoft][ODBC SQL Server Driver]Unicode conversion failed. The code page of the SQL server must be installed on the client system. - SQLSTATE: S1000

329/319 Thu Nov 01 15:26:58 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request

329/319 Thu Nov 01 15:26:58 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F98306

329/319 Thu Nov 01 15:27:00 2001 jdb_exet.c5284
JDB9900228 - Failed to commit user

(end of jde.log)

Is there an ODBC setting wrong? Which one?
 
Top