Hi Community,
I installed a clean 7.17.0 Oracle version and wanted to import a package from another environment. I tried several times to install it (deleting it, regenerating schemas, compiling, getting back to the VM Snapshot) and it doesn't work.
The installation log prints the following message for almost any of the package's objects (you can find here an example for the "Case" object) :
2022-03-28 16:31:20,550 Error occurred while saving schema database structure "Case" in package "". UId 00000000-0000-0000-0000-000000000000: Error "Invalid parameter binding
Parameter name: NEW" occurred when updating schema structure. SQL script text: "CREATE OR REPLACE TRIGGER "CREATIO"."TR117D32F98275453484111C6611BI"
BEFORE INSERT ON "Case" REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
IF (:NEW."Id" IS NULL) THEN
:NEW."Id" := "tspkg_Utilities"."fn_CreateGuid"();
END IF;
END "TR117D32F98275453484111C6611BI";"
Do you have an idea from where this issue can come from ? The base environment where I exported this specific package is working fine.
"Case" in package "". UId 00000000-0000-0000-0000-000000000000 --> This part seems really strange. It seems like it doesn't find the package where he must install the related object.
Thanks a lot for your help.
Best regards,
Jonathan
Like
Hello Jonathan,
Thank you for your Question. First of all, it would be useful to follow the basic checklist to be sure nothing is missed:
1) Versions of the exporter and importer environments should be the same. (In this case, both should be 7.17.0)
2) The product bundle should be the same (For example both should be Service Enterprise)
3) Check the Dependent packages. All of the dependent packages should exist in the final environment.
(More info regarding packages is available in the below article:
https://academy.creatio.com/docs/developer/development_tools/packages/p…)
If all of the above was checked and the issue still exists - there is one more thing that will be true only for specific Oracle versions.
ODAC v.12 support is planned as part of Oracle support for .Net Core in future Creatio versions.
Workaround - use ODAC v.11:
At the moment, we are seeing similar problems when using the 12th version of ODAC.
To solve the problems we recommend installing it on the 11th:
1) Remove ODAC v.12
2) Install ODAC v.11 x64 and test the case.
3) If the error persists, install ODAC version 11 x32, in the properties of the application pool setting "Enable 32-bit programs" to "true" and check the case.
Please perform the above actions and let me know the results.
Best Regards,
Dan
Denis Bidukha,
Thanks for your reply. I tried all of the steps listed above but nothing works.
When I try to use ODAC v.11, (64 or 32 bits) it prints that "OraOps12.dll" is missing and I can't even connect no more to the CRM.
The only way to make it work is with ODAC v.12. Although, when importing the package it does this "Invalid Paramteter binding" error...
Best regards,
Jonathan