OTN Discussion Forums : Application import error ...

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 12:17 AM

Exported Application from Win2003 Server to WinXP workstation.
Have done this many times Apex versions 1.5 to present without error.

both boxes running
DB 10g 201 and HTTP server 201 Companion Win32-bit no patched
APEX 2.2 patched to 2,2.1
utlrp run 0 errors
IE7

Able to import two other apps with no errors.

A-20001: GET_STMT error.
ORA-20001: Execution of the statement was unsuccessful.
ORA-06550: line 93, column 80:
PLS-00103: Encountered the symbol " "
when expecting one of the following: . ( * @ % & = - + ; < / >
at in is mod remainder not rem <
an exponent (**)>
<&
gt;
or != or ~= &
gt;
= &
lt;
= &
lt;
&
gt;
and or like LIKE2_ LIKE4_ LIKEC_ b

Error installing application.

*********

So where do I look??
Line 93 of import SQL script has no column 80
(includes counting all comment and white space lines)
Am I not counting correctly??

Is there some other log that would help me better locate the correct line
that appears to have punctutation error.

Or do I look in the application itself at all user inputted code.
Application is running without errors.

Any guidance from more advanced trouble shooters appreciated.

sspadafo

Posts: 16,581
Registered: 01/10/01

Re: Application import error
Posted: Dec 25, 2006 12:34 AM

in response to: eidercom

Reply

Janet,

First try to import the app using the export file, back into the same database, connected as the application parsing schema.

Then try to import it using the web interface into your workspace on apex.oracle.com.

If neither of those is successful, send us the file: htmldb_us@oracle.com.

Have you ever been able to import this app or did it start to fail at some point? If so, when? What version was it initially created in?

Scott

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 1:05 AM

in response to: sspadafo

Reply

On the originating server,
tried reimporting several of my backups into new APP ID number

same error

ORA-20001: GET_BLOCK Error. ORA-20001: GET_STMT error. ORA-20001: Execution of the statement was unsuccessful. ORA-06550: line 78, column 37: PLS-00103: Encountered the symbol " " when expecting one of the following: . ( * @ % & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ b
Error installing application.

***************

Applications were importing and exporting fine in Version 2.2.0.

I go back and forth quite a bit between the production server,
and development/demo on laptop.

I only developed this problem sometime after upgrade to 2.2.1 patch.
I have archived exports in version 2.2.0 and 2.2.1,
and both fail to import in 2.2.1.
Just this app, not two other apps that I upgraded to 2.2.0,
then patched 2.2.1 and exported.

**************

Is there a way to roll back the 2.2.1 patch??

Or do I just follow the kill my HTMLDB/APEX and re-install 2.2.0,
but do not apply the patch?

Kevin

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 1:29 AM

in response to: sspadafo

Reply

Define application parsing schema

the FLOWS_020200?

or the user schema the application was assigned to
when the workspace was developed?

sspadafo

Posts: 16,581
Registered: 01/10/01

Re: Application import error
Posted: Dec 25, 2006 1:46 AM

in response to: eidercom

Reply

Kevin (no, you are not Janet, sorry),

In SQL*Plus connect as the "owner" or parsing schema attribute of your application, assuming that attribute value in the export file is the schema that will be the "owner" of the application where you are importing it.

Alternately, you can connect as FLOWS_020200.

Here is what I've got so far: Using the web interface, if you import and change the app ID, it fails. What if you leave the app ID the same?

What happens when you import into apex.oracle.com? It will probably fail, but that will be a useful data point after which you can simply email me the file and I'll tell you what's wrong (htmldb_us@oracle.com).

Scott

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 9:34 AM

in response to: sspadafo

Reply

Import as APP 104, the original APP ID failed.

*******************

connected as FLOWS_020200

run import script with spool enabled
SQL> @c:\f104_2006_12_24.sql;

spool report
import terminated quickly

APPLICATION 104 - {My_App_name}
Set Credentials...
Check Compatibility...
API Last Extended:20060224
Your Current Version:20060224
This import is compatible with version: 20050501
COMPATIBLE (You should be able to run this import without issues.)
Set Application ID...
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (FLOWS_020200.WWV_FLOWS_FK) violated - parent
key not found
ORA-06512: at "FLOWS_020200.WWV_FLOW_API", line 511
ORA-06512: at line 3

***************

I think on the laptop,
not wanting to disturb a working app on the server,
I will follow Oracle procedure to remove APEX,
then reinstall APex 2.2,
but not install the 2.2.1 patch.

In the mean time,
I sent the import.sql to your email at Oracle Apex support team.

****************

I do not have an active account on apex.oracle.com
since my HTMLDB and APEX have worked so well over the last few years.

Thanks

Enjoy the holiday.

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 10:50 AM

in response to: sspadafo

Reply

On dev/demo laptop
Dropped APEX schemas
replaced 2.2.1 javascript update file with 2.2 version
Reinstalled Apex 2.2 without the 2.2.1 patch

Tried importing all my exports back to Sep 2006,
and all give the same error.

So....
I guess I will wait your analysis of the export sql provided to you by email
that might give clue as to what page/object(s) is(are) causing the import error.

Thanks

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 11:10 AM

in response to: sspadafo

Reply

Uninstalled IE7
Import error persists.

sspadafo

Posts: 16,581
Registered: 01/10/01

Re: Application import error
Posted: Dec 25, 2006 12:47 PM

in response to: eidercom

Reply

The export file is not complete...chopped off right in the middle of a statement. Maybe your DAD is configured wrong. Check that you followed all post-installation tasks and that the DAD characterset is AL32UTF8.

Scott

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 2:18 PM

in response to: sspadafo

Reply

I am using HTTP Server off the 10g 201 Companion Disk

DADS.CONF is empty

HTTPD.CONF is terminated by

include "C:\ORA\HTTP_Home\Apache\modplsql\conf\marvel.conf"

MARVEL.CONF is as follows

Alias /i/ "C:\ORA\HTTP_Home\Apex22\images/"
AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_manager.process_download
PlsqlDatabaseConnectString {my_ip_loopback_adapter}:1521:{my_sid} ServiceNameFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword {my_DADtool_pl_encrypted_password}
Allow from all
</Location>

I ran SQLPLUS from SYS

ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20;
SYSTEM ALTERED

I ran utlrp for the database FLOWS is installed in

no errors

*******

missing anything??

Is there any difference between using MARVEL.CONF or DADS.CONF??
The companion disk makes a DADS.CONF
Post install docs hint at making DADS blank and creating MARVEL
with the same information.

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 2:30 PM

in response to: sspadafo

Reply

Chopped off....

Chopped off in the middle as it goes right,
then no more entries for the rest of the script?

Or just chopped off to the right in a long line that gets to 80 or so
and is chopped off and shorter lines are okay??

Exports I use the DOS and UTF-8 options

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 3:48 PM

in response to: sspadafo

Reply

Studied quickly the export script.

I see the last few lines at the end is chopped off on the bad exports:

commit;
commit;
begin
execute immediate 'alter session se

*******************
instead on all my working exports is:

commit;
commit;
begin
execute immediate 'alter session set nls_numeric_characters='''||wwv_flow_api.g_nls_numeric_chars||'''';
end;
/
set verify on
set feedback on
prompt ...done

************************************************

Perhaps a bug in Apex 2.2 and 2.2.1 exporting function?
I see no indication that I can control this from the application setup.

**********************************************

I guess I should do a MS Word or TextPad COMPARE between
the working and broken export scripts.

sspadafo

Posts: 16,581
Registered: 01/10/01

Re: Application import error
Posted: Dec 25, 2006 3:53 PM

in response to: eidercom

Reply

Chopped of like the last 5 lines in the file that you sent are:

--application/end_environment
commit;
commit;
begin
execute immediate 'alter ses

Maybe you don't have the PL/SQL Web Toolkit patch applied.

Scott

eidercom

Posts: 144
Registered: 10/17/00

Application import error
Posted: Dec 25, 2006 4:01 PM

in response to: sspadafo

Reply

For 10g 201,
I have not installed any patches in the 10g 201 Win 32-bit
patch 1 through 8 patch-sets.

I have not installed any PL/SQL web toolkit patches (will look for those on metalink).

I have only upgraded Apex to 2.2 from 2.0 and then 2.2.1 on the server.

I have only installed Apex 2.2 and then the 2.2.1 patch on the XP workstation.

********************

On thing that is different:

On the server, Marvel points to the HTMLDB_PUBLIC_USER
and pls/htmldb
as backward web addressing compatibility.

On the laptop, Marvel points to the APEX_PULBIC_USER
and pls/apex.

I will make both the same.

*****************

Thanks for the help so far.

At least we found the error and now it is a matter of better
understanding how it is created by the Export function.

sspadafo

Posts: 16,581
Registered: 01/10/01

Re: Application import error
Posted: Dec 25, 2006 4:17 PM

in response to: eidercom

Reply

Keep APEX_PUBLIC_USER if that is what was installed.

And I found this: "Please review the README.txt file contained in the
directory htmldb/patch/bug4554072 for instructions about applying this
patch."

Scott