Kompiere Libero (Manufacturing) / Discussion / Help: import script errors (sqlj) + jnp errors

hi all,

i've got many errors while running ./RunDBRestore.sh .
the script finishes and i can run the app, but these are errors, not warnings.
you can see them at the end of the file.

also the bug related to jnp server listening at 1097 and not 1099 is still on (since 2005...),
i can get around it, but shutting down kompiere (jboss) requires a kill -9...

that's for admin stuff. see the functionality thread for other questions.

regards,
mlistus

======================
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "COMPIERE"."RV_C_INVOICE_VENDORMONTH"                    "
"    ("AD_CLIENT_ID","AD_ORG_ID","C_BPARTNER_ID","M_PRODUCT_CATEGORY_ID","DA"
"TEINVOICED","LINENETAMT","LINELISTAMT","LINELIMITAMT","LINEDISCOUNTAMT","LI"
"NEDISCOUNT","LINEOVERLIMITAMT","LINEOVERLIMIT","QTYINVOICED") AS "
"SELECT il.AD_Client_ID, il.AD_Org_ID,"
"      po.C_BPartner_ID, il.M_Product_Category_ID,"
"      firstOf(il.DateInvoiced, 'MM') AS DateInvoiced, --      DD Day, DY Week, MM Mon"
"th"
"      SUM(LineNetAmt) AS LineNetAmt,"
"      SUM(LineListAmt) AS LineListAmt,"
"      SUM(LineLimitAmt) AS LineLimitAmt,"
"      SUM(LineDiscountAmt) AS LineDiscountAmt,"
"      CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE"
"        ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS "
"LineDiscount,"
"      SUM(LineOverLimitAmt) AS LineOverLimitAmt,"
"      CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE"
"        100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2)"
" END AS LineOverLimit,"
"      SUM(QtyInvoiced) AS QtyInvoiced"
"FROM RV_C_InvoiceLine il"
"    INNER JOIN M_Product_PO po ON (il.M_Product_ID=po.M_Product_ID)"
"WHERE il.IsSOTrx='Y'"
"GROUP BY il.AD_Client_ID, il.AD_Org_ID, po.C_BPartner_ID, il.M_Product_Cate"
"gory_ID,"
"      firstOf(il.DateInvoiced, 'MM')"
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('META-INF/MANIFEST.MF', 0, 30, "
"0, 3, 484, 0); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('deployment/sqlj.ddr', 0, 30, 0"
", 9, 9478, 0); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Account', 0,"
" 29, 0, 4, 2234, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/BPartner', 0"
", 29, 0, 3, 1540, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Compiere', 0"
", 29, 0, 9, 8838, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Currency', 0"
", 29, 0, 6, 4689, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Invoice', 0,"
" 29, 0, 7, 6963, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Manufacturin"
"g', 0, 29, 0, 4, 2083, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Payment', 0,"
" 29, 0, 4, 3622, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/PaymentTerm'"
", 0, 29, 0, 7, 6494, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN     :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Product', 0,"
" 29, 0, 9, 8208, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
About to enable constraints...
Import terminated successfully with warnings.
-------------------------------------
Check System
Import may show some warnings. This is OK as long as the following does not show errors
-------------------------------------

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 11 04:29:02 2006

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

DBInfo
--------------------------------------------------------------------------------
DB_Name=XE, Language=ENGLISH_AUSTRALIA.WE8MSWIN1252, Host=photon-desktop, IP=127
.0.1.1, User=COMPIERE, ID=39, Session=164

DBA_Cleanup
Old AD_PInstance=14
>
COMPIEREPROPERTIES COMPIEREPROPERTY COMPIEREVERSION DOCUMENTNO INCOICEDISCOUNT
INCOICEOPEN INCOICEPAID
<
ERROR
Statistics computed: 0

PL/SQL procedure successfully completed.

Type
---------------------------------------------------------
Invalid
--------------------------------------------------------------------------------
STATUS
---------------------
FUNCTION
DOCUMENTNO
INVALID

FUNCTION
COMPIEREVERSION
INVALID

Type
---------------------------------------------------------
Invalid
--------------------------------------------------------------------------------
STATUS
---------------------

FUNCTION
COMPIEREPROPERTIES
INVALID

FUNCTION
COMPIEREPROPERTY

Type
---------------------------------------------------------
Invalid
--------------------------------------------------------------------------------
STATUS
---------------------
INVALID

FUNCTION
INCOICEOPEN
INVALID

FUNCTION

FUNCTION
INCOICEDISCOUNT
INVALID

7 rows selected.

no rows selected

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
INCOICEOPEN
FUNCTION                                      1          4          2
PLS-00311: the declaration of "org.compiere.sqlj.Invoice.open(int,int) return ja
va.math.BigDecimal" is incomplete or malformed
ERROR                                  311

INCOICEOPEN
FUNCTION 2 0 0
PL/SQL: Compilation unit analysis terminated
ERROR 0

DOCUMENTNO
FUNCTION 1 4 2
PLS-00311: the declaration of "org.compiere.sqlj.Manufacturing.documentNo(int) r
eturn java.lang.String" is incomplete or malformed

DOCUMENTNO
FUNCTION 2 0 0
PL/SQL: Compilation unit analysis terminated

COMPIEREPROPERTY
FUNCTION 1 4 2
PLS-00311: the declaration of "org.compiere.sqlj.Compiere.getProperty(java.lang.

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
String) return java.lang.String" is incomplete or malformed
ERROR                                  311

COMPIEREPROPERTY
FUNCTION 2 0 0

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
PL/SQL: Compilation unit analysis terminated
ERROR                                    0

INCOICEDISCOUNT
FUNCTION 1 4 2

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
PLS-00311: the declaration of "org.compiere.sqlj.Invoice.discount(int,java.sql.T
imestamp,int) return java.math.BigDecimal" is incomplete or malformed
ERROR                                  311

INCOICEDISCOUNT

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
FUNCTION                                      2          0          0
PL/SQL: Compilation unit analysis terminated
ERROR                                    0

INCOICEPAID

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
FUNCTION                                      1          4          2
PLS-00311: the declaration of "org.compiere.sqlj.Invoice.paid(int,int,int) retur
n java.math.BigDecimal" is incomplete or malformed
ERROR                                  311

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
INCOICEPAID
FUNCTION                                      2          0          0
PL/SQL: Compilation unit analysis terminated
ERROR                                    0

NAME
--------------------------------------------------------------------------------
TYPE                                   SEQUENCE       LINE   POSITION
------------------------------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE                   MESSAGE_NUMBER
--------------------------- --------------
COMPIEREPROPERTIES
FUNCTION                                      1          4          2
PLS-00311: the declaration of "org.compiere.sqlj.Compiere.getProperties() return
java.lang.String" is incomplete or malformed
ERROR                                  311

COMPIEREPROPERTIES
FUNCTION 2 0 0
PL/SQL: Compilation unit analysis terminated
ERROR 0

COMPIEREVERSION
FUNCTION 1 4 2
PLS-00311: the declaration of "org.compiere.sqlj.Compiere.getVersion() return ja
va.lang.String" is incomplete or malformed

COMPIEREVERSION
FUNCTION 2 0 0
PL/SQL: Compilation unit analysis terminated

14 rows selected.

Commit complete.

======================

import script errors (sqlj) + jnp errors

Forums

Help

import script errors (sqlj) + jnp errors document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

import script errors (sqlj) + jnp errors