Oracle 10g Release 2 OpenVMS I64 V8.4 porting OpenBravo ERP
Date: Thu, 10 Mar 2011 16:09:01 -0800 (PST)
Message-ID: <421df675-8437-4f57-bfb6-dcf585751a4f_at_m7g2000vbq.googlegroups.com>
And I can connect to the database and start the build and a ORASRV_NETV2 process dies with the following:
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=000000011036DA88, PC=000000000A1F66A0, PS=0000001B %TRACE-F-TRACEBACK, symbolic stack dump follows image module routine line rel PC abs PC
ORACLE lnxnur lnxnur 90029 0000000000000130
000000000A1F66A0
ORACLE kke kkenrm_internal 1507253 000000000002AE22
00000000044CB4F2
ORACLE kke kkenrms 1507446 000000000002C472
00000000044CCB42
ORACLE kke kkegvl 1507822 000000000002DF22
00000000044CE5F2
ORACLE kke kkepsl 1505613 000000000001A6A2
00000000044BAD72
ORACLE kke kkecdn 1504319 0000000000008C12
00000000044A92E2
ORACLE kko kkotap 1593625 00000000000E3732
000000000479EEE2
ORACLE kko kkoiqb 1587290 000000000007E8F2
000000000473A0A2
ORACLE kko kkooqb 1584126 0000000000047FA2
0000000004703752
ORACLE kko kkoqbc 1582340 000000000001EA12
00000000046DA1C2
ORACLE apa apakkoqb 1429628 0000000000007E22
00000000021BA002
ORACLE apa apaqbd 1429900 0000000000009822
00000000021BBA02
ORACLE kkqct kkqctCostTransfQB 1456834 0000000000007EB2
0000000004A1F472
ORACLE kkqct kkqctdrvSU 1460765 0000000000025322
0000000004A3C8E2
ORACLE nsoqbc nsotruns 1490081 0000000000002AC2
0000000006F62772
ORACLE nsoqbc nsoqbc 1489958 0000000000001CE2
0000000006F61992
ORACLE kkqct kkqctdrvTD 1462400 0000000000042682
0000000004A59C42
ORACLE kkqs kkqdrv 1517685 0000000000001BA2
0000000004A617F2
ORACLE kkqct kkqctdrvIT 1462309 0000000000041682
0000000004A58C42
ORACLE apa apadrv 1428430 0000000000002162
00000000021B4342
ORACLE opitca opitca 1545403 00000000000041D2
0000000006FDDBC2
ORACLE kks1 kksFullTypeCheck 1511740 0000000000000422
0000000004FB3162
ORACLE rpi rpiswu2 1429092 0000000000004812
0000000001B52182
ORACLE kks1 kksSetBindType 1515485 0000000000026F42
0000000004FD9C82
ORACLE kks kksfbc 1531795 0000000000019B52
0000000004FA2B22
ORACLE opiexe opiexe 1575172 0000000000005632
00000000010A0F12
ORACLE kpoal8 kpoal8 1463220 0000000000002ED2
0000000005982F82
ORACLE opiodr opiodr 1504090 0000000000002212
00000000010E16D2
ORACLE ttcpip ttcpip 412801 0000000000005562
000000000B17E252
ORACLE opitsk opitsk 1527361 0000000000002512
000000000110B5A2
ORACLE opiino opiino 1453303 0000000000004CD2
0000000006FB2852
ORACLE opiodr opiodr 1504090 0000000000002212
00000000010E16D2
ORACLE opidrv opidrv 1450763 0000000000002F62
00000000010DBCF2
ORACLE sou2o sou2o 1405727 0000000000000202
0000000001BA2662
ORACLE opimai main 1402531 0000000000000942
0000000000080BE2
ORACLE opimai __main 1402394 00000000000000D2
0000000000080372
PTHREAD$RTL THD_THREAD thdBase 245262 0000000000005BF2
FFFFFFFF844CAE72
PTHREAD$RTL THD_INIT pthread_main 245041 00000000000006B2
FFFFFFFF844806B2
0 FFFFFFFF80A495D2
FFFFFFFF80A495D2
DCL 0 000000000007CF62
000000007AE44F62
%TRACE-I-END, end of TRACE stack dump
as it is trying to apparently load this XML, which is followed by the Java Traceback:
[java] 31336 [main] INFO org.openbravo.data.Sqlc - File: ./org/
openbravo/erpCommon/ad_actionButton/CreateFrom_CRemittance_data
.xsql processed
[java] 37965 [main] ERROR org.openbravo.data.Sqlc - SQL error in
query: SELECT B.C_DEBT_PAYMENT_ID, L.NAME AS PAYMENTRU
LE, BP.NAME AS BPARTNER,
[java]
Ad_Column_Identifier(to_char('C_Invoice'), to_char(i.C_Invoice_ID),
to_char(?)) AS INVOICE, B.DATEPL
ANNED,
[java] B.AMOUNT, B.ISO_CODE, B.Org,
[java] (CASE ? WHEN 'Y' THEN
B.C_DEBT_PAYMENT_ID ELSE '-1' END) AS MARCAR_ID,
[java] (CASE ? WHEN 'Y' THEN '-1' ELSE
B.C_DEBT_PAYMENT_ID END) AS DISABLE_INPUTS, L1.name as status, '' as
line
[java] FROM ( SELECT
[java] '0' AS RN1, A.* FROM (
[java] SELECT DP.C_DEBT_PAYMENT_ID, DP.AMOUNT,
DP.PAYMENTRULE, DP.DATEPLANNED, DP.C_BPARTNER_ID,
[java] DP.C_INVOICE_ID, DP.STATUS,
C.ISO_CODE, O.NAME AS ORG
[java] FROM C_DEBT_PAYMENT DP, C_CURRENCY C,
AD_Org O
[java] WHERE DP.ISACTIVE = 'Y'
[java] AND DP.AD_Org_ID = O.AD_Org_ID
[java] AND DP.AD_CLIENT_ID IN (
[java] '1')
[java] AND DP.AD_ORG_ID IN (
[java] '1')
[java] AND DP.AD_ORG_ID IN (
[java] '2')
[java] AND DP.C_CURRENCY_ID =
C.C_CURRENCY_ID
[java] AND DP.C_BPARTNER_ID = ?
[java] AND DP.PAYMENTRULE = ?
[java] AND DP.DATEPLANNED >= TO_DATE(?)
[java] AND DP.DATEPLANNED <= TO_DATE(?)
[java] AND DP.ISRECEIPT = ?
[java] AND DP.AMOUNT >= TO_NUMBER(?)
[java] AND DP.AMOUNT <= TO_NUMBER(?)
[java] AND ABS(DP.AMOUNT) < TO_NUMBER(?)
[java] AND DP.STATUS = ?
[java] AND CASE
[java] WHEN (DP.ISVALID = 'N') THEN 'I'
[java] WHEN (DP.C_CASHLINE_ID IS NOT NULL
OR DP.C_BANKSTATEMENTLINE_ID IS NOT NULL) THEN 'C'
[java] WHEN (DP.CANCEL_PROCESSED = 'Y'
AND DP.ISPAID = 'N') THEN 'W'
[java] WHEN (DP.CANCEL_PROCESSED = 'Y'
OR(DP.C_Settlement_Cancel_ID IS NULL AND DP.GENERATE_PROCESSED =
'Y' AND DP.ISPAID = 'Y')) THEN 'A'
[java] ELSE 'P'
[java] END = 'P'
[java] AND NOT EXISTS (SELECT 1 FROM
C_BankStatementLine l WHERE DP.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID)
[java] AND NOT EXISTS (SELECT 1 FROM
C_CashLine l WHERE DP.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID)
[java] AND NOT EXISTS (SELECT 1 FROM
C_RemittanceLine rl, C_Remittance r, C_REMITTANCE_TYPE rt
[java]
WHERE r.C_REMITTANCE_ID = rl.C_REMITTANCE_ID
[java]
AND rt.C_REMITTANCE_TYPE_ID = r.C_REMITTANCE_TYPE_ID
[java]
AND r.PROCESSED = 'Y'
[java]
AND rt.STATUS_RETURNED <> dp.STATUS
[java]
AND rl.C_DEBT_PAYMENT_ID = dp.C_DEBT_PAYMENT_ID)
[java] ORDER BY DP.DATEPLANNED DESC) A ) B
LEFT JOIN AD_REF_LIST_V L ON B.PAYMENTRULE = L.VALUE
[java]
AND L.AD_REFERENCE_ID = '195' [java]
AND L.AD_LANGUAGE = ?
[java]
left join C_BPARTNER BP on B.C_BPARTNER_ID = BP.C_BPARTNER_I D
[java]
left join C_INVOICE I on B.C_INVOICE_ID = I.C_INVOICE_ID
[java]
left join AD_REF_LIST_V L1 on B.STATUS = L1.value
[java]
and l1.ad_reference_id = '800070'
[java]
and l1.Ad_Language = ?
[java] WHERE 1=1
[java]
[java] java.sql.SQLRecoverableException: No more data to read
from socket
[java] at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:
101)
[java] at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:
133)
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
199)
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
263)
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
271)
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
445)
[java] at
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1053)
[java] at
oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:
588)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:
194)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:
791)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:
866)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:
1186)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:
3387)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:
3431)
[java] at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:
1491)
[java] at org.openbravo.data.Sqlc.query(Sqlc.java:713)
[java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:533)
[java] at
org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[java] at
org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown
Source)
[java] at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
$FragmentContentDispatcher.dispatch(Unknown Source)
[java] at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
[java] at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] at org.apache.xerces.parsers.XMLParser.parse(Unknown
Source)
[java] at
org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:340)
[java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:265)
[java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:244)
[java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:244)
[java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:244)
[java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:244)
[java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
This is during an ANT 1.7.1 "install.source" of the OpenBravo ERP Ver. 2.50 MP 23 application. It has already performed thousands of SQL transactions against the the DB so have connectivity and it is only the one network server which dies and it is replaced when a new invocation comes along.
I am trying to figure out if it is an issue with the quotas or something of that nature on OpenVMS or if I need to consider a mod to the SQL in some fashion. Let's face it quotas are a lot easier to handle some I control them in the long run and have little control over the open source code - would rather it
Yes, I know I could move this to Linux or Unix, I have no desire to do that. My goal is to get OpenBravo ERP working on OpenVMS. Oracle is a "supported" DB for the application, although I believe it is really secondardy to PostgreSQL - that would be a nice port too but later...
A SHOW PROCESS/ALL of a NETV2 process before it died is:
10-MAR-2011 16:51:29.36 User: ORACLE Process ID: 0000097B
Node: LEEDS Process name:
"ORA_XEC4462"
Terminal:
User Identifier: [BRAVO,ORACLE]
Base priority: 4
Default file spec: Not available
Number of Kthreads: 1 (System-wide limit: 2)
Devices allocated: BG36355:
Process Quotas:
Account name:
CPU limit: Infinite Direct I/O limit: 1200 Buffered I/O byte count quota: 997632 Buffered I/O limit: 1200 Timer queue entry quota: 15 Open file quota: 96 Paging file quota: 1938528 Subprocess quota: 32 Default page fault cluster: 64 AST quota: 997 Enqueue quota: 995 Shared file limit: 0 Max detached processes: 0 Max active jobs: 0 Accounting information: Buffered I/O count: 341687 Peak working set size: 81424 Direct I/O count: 53 Peak virtual size: 4650736 Page faults: 40881 Mounted volumes: 0 Images activated: 2 Elapsed CPU time: 0 00:01:06.76 Connect time: 0 00:04:44.75 Authorized privileges: ALTPRI CMKRNL EXQUOTA GROUP GRPNAM IMPERSONATE LOG_IO NETMBX OPER PFNMAP PRMGBL PRMMBX READALL SHARE SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX WORLD Process privileges: ALTPRI may set any priority value CMKRNL may change mode to kernel EXQUOTA may exceed disk quota GROUP may affect other processes in same group GRPNAM may insert in group logical name table IMPERSONATE may impersonate another user LOG_IO may do logical i/o NETMBX may create network device OPER may perform operator functions PFNMAP may map to specific physical pages PRMGBL may create permanent global sections PRMMBX may create permanent mailbox READALL may read anything as the owner SHARE may assign channels to non-shared devices SYSGBL may create system wide global sections SYSLCK may lock system wide resources SYSNAM may insert in system logical name table SYSPRV may access objects via system protection TMPMBX may create temporary mailbox WORLD may affect other processes in the world Process rights: ORACLE resourceINTERACTIVE
REMOTE
ORA_DBA
ORA_SGA subsystemVMS$BUFFER_OBJECT_USER System rights:
SYS$NODE_LEEDS Auto-unshelve: on
Image Dump: off
Soft CPU Affinity: off
Parse Style: Traditional
Case Lookup: Blind
Symlink search mode: No wildcard
Units: Blocks
Token Size: Traditional
Home RAD: 0
Scheduling class name: none
There is 1 process in this job:
ORA_XEC4462 (*) Thanks.
Am a newby here, I did some development against an Oracle RDBMS environment back in the early '90s and had been involved with OpenVMS since before it was released... Getting back into this to expand the open source on OpenVMS and get a good application available.
If you need more detail as to what the application is trying to do or anything else just ask. I'll work it up and get it back here.
I look forward to any suggestions and help folks can provide.
Regards,
Bill. Received on Thu Mar 10 2011 - 18:09:01 CST