2Pack(Fixed Asset) fails

Before you even think of trying Compiere. What you should worry about. What are the issues? These are stuff that our prospects and clients went through. No holds barred. We tell it like it is.

2Pack(Fixed Asset) fails

Postby aries211 » Fri Sep 15, 2006 12:43 pm

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-
oracle 10g

Thanks in advance

Best Regards!
aries :(
Posts: 11
Joined: Wed Mar 29, 2006 9:32 am
Location: China

Postby afalcone » Fri Sep 15, 2006 7:27 pm

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

Posts: 120
Joined: Fri Jun 24, 2005 4:09 am
Location: Argentina

Postby aries211 » Mon Sep 18, 2006 10:22 am

Thanks for your kind suggestion, afalcone :D
Posts: 11
Joined: Wed Mar 29, 2006 9:32 am
Location: China

Return to PreSales Bites

Who is online

Users browsing this forum: No registered users and 1 guest