Hi all!

While upgrading from 1.5 to 1.6 we've get the following error:
Executing 006_engine_postInstall.sql:
PL/SQL procedure successfully completed
PL/SQL procedure successfully completed
begin
bdf_datasourcedef_gen.refreshdatasettables;
end;
ORA-00910: specified length too long for its datatype
ORA-06512: at "PSFSDEV_PI.BDF_DATASOURCEDEF_GEN", line 6521
ORA-06512: at "PSFSDEV_PI.BDF_DATASOURCEDEF_GEN", line 6576
ORA-06512: at line 3
PL/SQL procedure successfully completed
1 row updated
1 row updated
Commit complete

After the upgrade is complete there are still some DS_*-package bodies invalid:
Compilation errors for PACKAGE BODY PSFSDEV_PI.DS_59768
#13#10Error: PL/SQL: ORA-00904: "BDF_ORIGINALORDER_NR": invalid identifier
Line: 64
Text: and BDF_ORIGINALORDER_NR<=in_originalOrder_nr
#13#10Error: PL/SQL: SQL Statement ignored
...

Regards,

Frank

asked 11 Jan '14, 11:28

Frank's gravatar image

Frank
2314
accept rate: 0%


Hi Frank,

Sorry for the inconvenience caused. First, please run the script below in PSFSDEV_PI schema to find the id of the datasource definition which causes the problem:

declare
  v_datasourceDef_oid number;
begin
  for rec in (select dd.bdf_datasourcedef_oid from t_bdf_datasourceDef dd ) loop
    v_datasourceDef_oid := rec.bdf_datasourcedef_oid;
    bdf_datasourcedef_gen.datasetTableCreateOrReplace(v_datasourceDef_oid);
  end loop;
exception
  when others then
    dbms_output.put_line('bdf_datasourcedef_oid>> ' || v_datasourceDef_oid);
    dbms_output.put_line('sqlerrm>> ' || sqlerrm);
    raise;
end;

Copy the bdf_datasourcedef_oid value causing the exception. Then, run the two queries below after replacing the v_bdf_datasourcedef_oid with the value that you have copied. Please send the results of these queries to contact@theformspider.com.

select * 
from t_bdf_datasourcedefatrib 
where bdf_datasourcedef_oid = v_bdf_datasourcedef_oid

select * 
from t_bdf_domain d 
where exists(
              select 1 
              from t_bdf_datasourcedefatrib dda 
              where dda.bdf_datasourcedef_oid = v_bdf_datasourcedef_oid
                and dda.bdf_domain_oid = d.bdf_domain_oid 
            )

Best Regards,
Ibrahim

link

answered 11 Jan '14, 14:16

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×7

Asked: 11 Jan '14, 11:28

Seen: 824 times

Last updated: 11 Jan '14, 14:16


© Copyright Gerger 2017