ERROR : in_panel_oid :22845(init)

Hi Yalim,

we upgraded to 1.9, but a developer license from 1.8 was not run there. I don't have a license script for 1.9 yet.

In test env everything is OK, so have no idea why application has problem in LIVE env. Is above error linked to licensing?

So far I had to downgrade back to 1.8.1 version in LIVE.

Tomas

Hello folks,

any idea how to track what's wrong? It's pointing to formspider's packages, so have no clue what's wrong.

Regards, Tomas

For importing application into LIVE and, we use an EXPORT script from DEV env and then IMPORT script into LIVE db. Could something change with upgrade 1.9, so export/import scripts does not work correctly?

Please see my scripts below:

1.Application export, from dev env.

declare
  cursor c is
     select NAME_TX, DEV.API_FS_APP_VERSION.get_version_ag_doprava version
       from T_BDF_APPLICATION
       where NAME_TX = 'AG Doprava';

  v_xml                 xmltype;
  v_applicationName_tx  varchar2(255);
  v_directoryName_tx    varchar2(255) := 'FORMSPIDER_DIR';
  ------------------------------------------------------------------------------
  procedure saveCLOBtoFile(in_directoryName_tx varchar2, in_filename_tx varchar2, in_application_xml xmltype)
  is
  begin
    dbms_xslprocessor.clob2file(xmltype.extract(in_application_xml, '/*').getClobVal(), in_directoryName_tx, in_filename_tx);
  end;
  ------------------------------------------------------------------------------
BEGIN
  for x in c loop
    v_applicationName_tx := x.NAME_TX;
    v_xml := api_application.export(v_applicationName_tx);
    saveCLOBtoFile(v_directoryName_tx, v_applicationName_tx||'-'||x.version||'.xml',v_xml);
  end loop;
END;
/

exit;

2.Import exported application into LIVE db.

   declare
      v_oracleDirectory_tx varchar2(255) := 'FORMSPIDER_DIR'; 
      v_applicationName_tx varchar2(255) := 'AG Doprava';
      v_xmlFileName_tx varchar2(255) := v_applicationName_tx||'-'||DEV.API_FS_APP_VERSION.get_version_ag_doprava||'.xml';
      v_cl clob;

      v_file bfile;
      v_destoffset number:=1;
      v_srcoffset number:=1;
      v_warning number:=0;
      v_context number:=0;

      v_objectRecord_tt bdf_etl.tt_importObjects;

    begin

      bdf_application_api.applicationdelete(in_application_oid=>bdf_application_qry.getid(v_applicationName_tx), in_cascade_yn=>'Y');

      dbms_lob.createtemporary(v_cl,true);
      v_file  := BFILENAME(v_oracleDirectory_tx, v_xmlFileName_tx);

      dbms_lob.open(v_file, dbms_lob.lob_readonly);

      dbms_lob.loadclobfromfile(v_cl, v_file, DBMS_LOB.LOBMAXSIZE , v_destoffset, v_srcoffset, nls_charset_id('AL32UTF8'), v_context, v_warning);

      dbms_lob.close(v_file);

      bdf_etl.load(in_bdf_xml=>xmltype(v_cl),
                   in_importOption_cd =>'AsNewApplication',           -- leave it as it is
                   in_projectOption_cd=>bdf_constant_etl.etlcreateOrReplace,
                   in_applicationOption_cd=>bdf_constant_etl.etlcreateOrReplace,
                   in_importObjects_tt=>v_objectRecord_tt);

      commit;
    end;
    /

    exit;

Both scripts run fine, but when application is run in dev env, above formspider error occurs.