Page 1 of 1

2Pack(Fixed Asset) fails

PostPosted: Fri Sep 15, 2006 12:43 pm
by aries211
Hi all.

I've tested 2pack(Fixed Asset) , but I met some problems:

Command: sh ./FAPack_Run_BuildJar.sh


1 [java] 03:14:48.641 GenericPO.save: Nothing changed - A_Depreciation_Table_Detail
[java] -----------> GenericPO.set_ValueNoCheck: A_Depreciation_Table_Detail_ID - Class invalid: class java.lang.String, Should be class java.lang.Integer: 1001322

2 [java] 03:16:55.980 X_AD_Role.saveNew: AD_Role - AD_Role_ID=1000000
[java] 03:16:56.691 DB.getSQLValue: No Value SELECT AD_Window_ID FROM AD_Window WHERE Name= ? - Param1=Packages Installed
[java] 03:16:56.739 MIssue.create: Insert INTO AD_Window_Access(AD_Client_ID, AD_Org_ID, CreatedBy, UpdatedBy, AD_Role_ID, AD_Window_ID, isActive, isReadWrite) VALUES( 0, 0, 0, 0, 1000000, -1, 'Y', 'Y') [null]

The values are 0, so I met integrate constraint for the program cannot find the foreign key.


3 [java] 04:36:14.129 MIssue.saveNew: AD_Issue - AD_Issue_ID=1000007
[java] ===========> PackIn.startElement: SQLSatement
[java] java.sql.SQLException: ORA-00900: invalid SQL statement
[java] ; State=42000; ErrorCode=900
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
[java] at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
[java] at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:165)
[java] at PackInHandler.startElement(Unknown Source)
[java] at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1674)
[java] at org.apache.crimson.parser.Parser2.content(Parser2.java:1963)
[java] at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1691)
[java] at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
[java] at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
[java] at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
[java] at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
[java] at javax.xml.parsers.SAXParser.parse(SAXParser.java:311)
[java] at PackIn.importXML(Unknown Source)
[java] at PackIn.main(Unknown Source)

My System is: gentoo
jdk: sun-jdk-1.5.0.08
compiere-253b
oracle 10g


Thanks in advance

Best Regards!
aries :(

PostPosted: Fri Sep 15, 2006 7:27 pm
by afalcone
Hi aries,

I believe that you should be the post in the OSLabs forum.

http://www.oslabs.org/index.php?option= ... &Itemid=26

Rob can help you with this error surely.

Kind regards

Alejandro

PostPosted: Mon Sep 18, 2006 10:22 am
by aries211
Thanks for your kind suggestion, afalcone :D