ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database Problem

Post new topic  Reply to topic
 Database Problem « View previous topic :: View next topic » 
Author Message
MB Developer
PostPosted: Tue Sep 30, 2014 1:27 am    Post subject: Database Problem Reply with quote

Disciple

Joined: 03 Feb 2014
Posts: 179
Hi All,
Greetings ....


Previously my database is working,Now it is not working..


1. Create DNS
2.
Code:
    C:\Program Files\IBM\MQSI\8.0.0.0>mqsisetdbparms BRK1 -n Invoice_DSN -u dbadmin-p oracle
BIP8071I: Successful command completion.

C:\Program Files\IBM\MQSI\8.0.0.0>mqsireload BRK1 -e EG1
BIP8071I: Successful command completion.



3. MQInput node --> Compute --> MQOutput

4. In Compute node Give
Data Source -- Invoice_DSN

Code:
Code:
   CALL CopyMessageHeaders();
      -- CALL CopyEntireMessage();
      
      SET OutputRoot.XMLNSC.CUSTOMER.DATA[] = PASSTHRU('SELECT * FROM CUSTOMER WHERE CUSTOMERID = ?',InputRoot.XMLNSC.CUSTOMER.ID);



5. Input Message : <CUSTOMER><ID>1001</ID></CUSTOMER>

6. When run this flow no message will come.


7. When debug this flow " Node re-throwing exception" is occurred .


Please give the solution for this problem............
_________________
Thanks....
Back to top
View user's profile Send private message
smdavies99
PostPosted: Tue Sep 30, 2014 2:35 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
What does a usertrace output show?
Have you thought about adding a Trace Node before the compute node and setting the output to ${Root}

Does it show the messages tree as you would expect it to be?

Does the mqsicvp command work on your DSN?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
tank_n_spank
PostPosted: Tue Sep 30, 2014 3:23 am    Post subject: Reply with quote

Apprentice

Joined: 02 Sep 2014
Posts: 37
Try running mqsicvp as smdavies99 pointed out.

Also do you have a database definition defined?

Quote:
When debug this flow " Node re-throwing exception" is occurred .


Is not the actual reason, you will have to expand it a little bit more and check the error code.
Back to top
View user's profile Send private message
MB Developer
PostPosted: Tue Sep 30, 2014 5:10 am    Post subject: Reply with quote

Disciple

Joined: 03 Feb 2014
Posts: 179
Hi smdavies99,tank_n_spank..

thanks for responding ..

I get this error in my trace...

Code:
 2014-09-30 18:38:31.874881

Exception List : ( ['MQROOT' : 0xb54f560]
  (0x01000000:Name):RecoverableException = (
    (0x03000000:NameValue):File              = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbComputeNode.cpp' (CHARACTER)
    (0x03000000:NameValue):Line              = 497 (INTEGER)
    (0x03000000:NameValue):Function          = 'ImbComputeNode::evaluate' (CHARACTER)
    (0x03000000:NameValue):Type              = 'ComIbmComputeNode' (CHARACTER)
    (0x03000000:NameValue):Name              = 'DB_MF#FCMComposite_1_3' (CHARACTER)
    (0x03000000:NameValue):Label             = 'DB_MF.Compute' (CHARACTER)
    (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
    (0x03000000:NameValue):Severity          = 3 (INTEGER)
    (0x03000000:NameValue):Number            = 2230 (INTEGER)
    (0x03000000:NameValue):Text              = 'Caught exception and rethrowing' (CHARACTER)
    (0x01000000:Name     ):Insert            = (
      (0x03000000:NameValue):Type = 14 (INTEGER)
      (0x03000000:NameValue):Text = 'DB_MF.Compute' (CHARACTER)
    )
    (0x01000000:Name     ):DatabaseException = (
      (0x03000000:NameValue):File              = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
      (0x03000000:NameValue):Line              = 2260 (INTEGER)
      (0x03000000:NameValue):Function          = 'ImbOdbcConnection::checkRcInner' (CHARACTER)
      (0x03000000:NameValue):Type              = '' (CHARACTER)
      (0x03000000:NameValue):Name              = '' (CHARACTER)
      (0x03000000:NameValue):Label             = '' (CHARACTER)
      (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
      (0x03000000:NameValue):Severity          = 3 (INTEGER)
      (0x03000000:NameValue):Number            = 2393 (INTEGER)
      (0x03000000:NameValue):Text              = 'Root SQL exception' (CHARACTER)
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 2 (INTEGER)
        (0x03000000:NameValue):Text = '-1' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = 'HAI' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 14 (INTEGER)
        (0x03000000:NameValue):Text = 'odbc32.dll' (CHARACTER)
      )
      (0x01000000:Name     ):DatabaseException = (
        (0x03000000:NameValue):File     = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
        (0x03000000:NameValue):Line     = 2446 (INTEGER)
        (0x03000000:NameValue):Function = 'ImbOdbcConnection::checkRcInner' (CHARACTER)
        (0x03000000:NameValue):Type     = '' (CHARACTER)
        (0x03000000:NameValue):Name     = '' (CHARACTER)
        (0x03000000:NameValue):Label    = '' (CHARACTER)
        (0x03000000:NameValue):Catalog  = 'BIPmsgs' (CHARACTER)
        (0x03000000:NameValue):Severity = 3 (INTEGER)
        (0x03000000:NameValue):Number   = 2322 (INTEGER)
        (0x03000000:NameValue):Text     = 'Child SQL exception' (CHARACTER)
        (0x01000000:Name     ):Insert   = (
          (0x03000000:NameValue):Type = 5 (INTEGER)
          (0x03000000:NameValue):Text = 'HY000' (CHARACTER)
        )
        (0x01000000:Name     ):Insert   = (
          (0x03000000:NameValue):Type = 2 (INTEGER)
          (0x03000000:NameValue):Text = '28000' (CHARACTER)
        )
        (0x01000000:Name     ):Insert   = (
          (0x03000000:NameValue):Type = 5 (INTEGER)
          (0x03000000:NameValue):Text = '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-28000: the account is locked' (CHARACTER)
        )
      )
    )
  )
)

( ['MQROOT' : 0xb54f230]
  (0x01000000:Name  ):Properties = ( ['MQPROPERTYPARSER' : 0xb5c1b70]
    (0x03000000:NameValue):MessageSet             = '' (CHARACTER)
    (0x03000000:NameValue):MessageType            = '' (CHARACTER)
    (0x03000000:NameValue):MessageFormat          = '' (CHARACTER)
    (0x03000000:NameValue):Encoding               = 546 (INTEGER)
    (0x03000000:NameValue):CodedCharSetId         = 437 (INTEGER)
    (0x03000000:NameValue):Transactional          = TRUE (BOOLEAN)
    (0x03000000:NameValue):Persistence            = FALSE (BOOLEAN)
    (0x03000000:NameValue):CreationTime           = GMTTIMESTAMP '2014-09-30 13:08:28.090' (GMTTIMESTAMP)
    (0x03000000:NameValue):ExpirationTime         = -1 (INTEGER)
    (0x03000000:NameValue):Priority               = 0 (INTEGER)
    (0x03000000:NameValue):ReplyIdentifier        = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):ReplyProtocol          = 'MQ' (CHARACTER)
    (0x03000000:NameValue):Topic                  = NULL
    (0x03000000:NameValue):ContentType            = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceType     = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceToken    = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourcePassword = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceIssuedBy = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedType     = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedToken    = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedPassword = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedIssuedBy = '' (CHARACTER)
  )
  (0x01000000:Name  ):MQMD       = ( ['MQHMD' : 0xb553200]
    (0x03000000:NameValue):SourceQueue      = 'A' (CHARACTER)
    (0x03000000:NameValue):Transactional    = TRUE (BOOLEAN)
    (0x03000000:NameValue):Encoding         = 546 (INTEGER)
    (0x03000000:NameValue):CodedCharSetId   = 437 (INTEGER)
    (0x03000000:NameValue):Format           = '        ' (CHARACTER)
    (0x03000000:NameValue):Version          = 2 (INTEGER)
    (0x03000000:NameValue):Report           = 0 (INTEGER)
    (0x03000000:NameValue):MsgType          = 8 (INTEGER)
    (0x03000000:NameValue):Expiry           = -1 (INTEGER)
    (0x03000000:NameValue):Feedback         = 0 (INTEGER)
    (0x03000000:NameValue):Priority         = 0 (INTEGER)
    (0x03000000:NameValue):Persistence      = 0 (INTEGER)
    (0x03000000:NameValue):MsgId            = X'414d512042524b514d47522020202020558d2a5420003115' (BLOB)
    (0x03000000:NameValue):CorrelId         = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):BackoutCount     = 0 (INTEGER)
    (0x03000000:NameValue):ReplyToQ         = '                                                ' (CHARACTER)
    (0x03000000:NameValue):ReplyToQMgr      = 'BRKQMGR                                         ' (CHARACTER)
    (0x03000000:NameValue):UserIdentifier   = 'SURESH      ' (CHARACTER)
    (0x03000000:NameValue):AccountingToken  = X'1601051500000028d3dcb3b8007357b603f894ec03000000000000000000000b' (BLOB)
    (0x03000000:NameValue):ApplIdentityData = '                                ' (CHARACTER)
    (0x03000000:NameValue):PutApplType      = 11 (INTEGER)
    (0x03000000:NameValue):PutApplName      = 's\SURESH\Desktop\rfhutil.exe' (CHARACTER)
    (0x03000000:NameValue):PutDate          = DATE '2014-09-30' (DATE)
    (0x03000000:NameValue):PutTime          = GMTTIME '13:08:28.090' (GMTTIME)
    (0x03000000:NameValue):ApplOriginData   = '    ' (CHARACTER)
    (0x03000000:NameValue):GroupId          = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):MsgSeqNumber     = 1 (INTEGER)
    (0x03000000:NameValue):Offset           = 0 (INTEGER)
    (0x03000000:NameValue):MsgFlags         = 0 (INTEGER)
    (0x03000000:NameValue):OriginalLength   = -1 (INTEGER)
  )
  (0x01000000:Folder):XMLNSC     = ( ['xmlnsc' : 0xe999d0]
    (0x01000000:Folder):EMP = (
      (0x03000000:PCDataField):DEPTNO = '20' (CHARACTER)
    )
  )
)   

_________________
Thanks....
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue Sep 30, 2014 5:17 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
MB Developer wrote:
(0x03000000:NameValue):Text = '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-28000: the account is locked' (CHARACTER)
Back to top
View user's profile Send private message
MB Developer
PostPosted: Tue Sep 30, 2014 8:54 pm    Post subject: Reply with quote

Disciple

Joined: 03 Feb 2014
Posts: 179
Hi mqjeff,

Thanks for reply ...

Now I create a new user for DB.
With that user all DB operations are working (for default tables).

I create a new table CUSTOMER with PK.

for CUSTOMER table INSERT, UPDATE,DELETE Operations are working.

but when SELECT * FROM CUSTOMER or any other Select statement ... It is not working...


Please find the Trace node error:

Code:
 2014-10-01 10:17:32.054676

Exception List : ( ['MQROOT' : 0xaf73af0]
  (0x01000000:Name):RecoverableException = (
    (0x03000000:NameValue):File                 = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbComputeNode.cpp' (CHARACTER)
    (0x03000000:NameValue):Line                 = 497 (INTEGER)
    (0x03000000:NameValue):Function             = 'ImbComputeNode::evaluate' (CHARACTER)
    (0x03000000:NameValue):Type                 = 'ComIbmComputeNode' (CHARACTER)
    (0x03000000:NameValue):Name                 = 'Sample_DB_MF#FCMComposite_1_3' (CHARACTER)
    (0x03000000:NameValue):Label                = 'Sample_DB_MF.Compute' (CHARACTER)
    (0x03000000:NameValue):Catalog              = 'BIPmsgs' (CHARACTER)
    (0x03000000:NameValue):Severity             = 3 (INTEGER)
    (0x03000000:NameValue):Number               = 2230 (INTEGER)
    (0x03000000:NameValue):Text                 = 'Caught exception and rethrowing' (CHARACTER)
    (0x01000000:Name     ):Insert               = (
      (0x03000000:NameValue):Type = 14 (INTEGER)
      (0x03000000:NameValue):Text = 'Sample_DB_MF.Compute' (CHARACTER)
    )
    (0x01000000:Name     ):RecoverableException = (
      (0x03000000:NameValue):File              = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp' (CHARACTER)
      (0x03000000:NameValue):Line              = 650 (INTEGER)
      (0x03000000:NameValue):Function          = 'SqlStatementGroup::execute' (CHARACTER)
      (0x03000000:NameValue):Type              = 'ImbESQLManager' (CHARACTER)
      (0x03000000:NameValue):Name              = 'ImbESQLManager' (CHARACTER)
      (0x03000000:NameValue):Label             = 'ImbESQLManager' (CHARACTER)
      (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
      (0x03000000:NameValue):Severity          = 3 (INTEGER)
      (0x03000000:NameValue):Number            = 2488 (INTEGER)
      (0x03000000:NameValue):Text              = 'Error detected, rethrowing' (CHARACTER)
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = '.Sample_DB_MF_Compute.Main' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = '8.5' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = 'SET OutputRoot.XMLNSC.CUSTOMER.CUSTOMERDATA[ ] = DEFAULTPASSTHRU('SELECT * FROM CUSTOMER');' (CHARACTER)
      )
      (0x01000000:Name     ):DatabaseException = (
        (0x03000000:NameValue):File              = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
        (0x03000000:NameValue):Line              = 3259 (INTEGER)
        (0x03000000:NameValue):Function          = 'ImbOdbcStatement::checkRcInner' (CHARACTER)
        (0x03000000:NameValue):Type              = '' (CHARACTER)
        (0x03000000:NameValue):Name              = '' (CHARACTER)
        (0x03000000:NameValue):Label             = '' (CHARACTER)
        (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
        (0x03000000:NameValue):Severity          = 3 (INTEGER)
        (0x03000000:NameValue):Number            = 2321 (INTEGER)
        (0x03000000:NameValue):Text              = 'Root SQL exception' (CHARACTER)
        (0x01000000:Name     ):Insert            = (
          (0x03000000:NameValue):Type = 2 (INTEGER)
          (0x03000000:NameValue):Text = '-1' (CHARACTER)
        )
        (0x01000000:Name     ):Insert            = (
          (0x03000000:NameValue):Type = 14 (INTEGER)
          (0x03000000:NameValue):Text = 'odbc32.dll' (CHARACTER)
        )
        (0x01000000:Name     ):DatabaseException = (
          (0x03000000:NameValue):File     = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
          (0x03000000:NameValue):Line     = 3437 (INTEGER)
          (0x03000000:NameValue):Function = 'ImbOdbcStatement::checkRcInner' (CHARACTER)
          (0x03000000:NameValue):Type     = '' (CHARACTER)
          (0x03000000:NameValue):Name     = '' (CHARACTER)
          (0x03000000:NameValue):Label    = '' (CHARACTER)
          (0x03000000:NameValue):Catalog  = 'BIPmsgs' (CHARACTER)
          (0x03000000:NameValue):Severity = 3 (INTEGER)
          (0x03000000:NameValue):Number   = 2322 (INTEGER)
          (0x03000000:NameValue):Text     = 'Child SQL exception' (CHARACTER)
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 5 (INTEGER)
            (0x03000000:NameValue):Text = 'HYC00' (CHARACTER)
          )
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 2 (INTEGER)
            (0x03000000:NameValue):Text = '0' (CHARACTER)
          )
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 5 (INTEGER)
            (0x03000000:NameValue):Text = '[IBM][ODBC Oracle Wire Protocol driver]Optional feature not implemented.' (CHARACTER)
          )
        )
      )
    )
  )
)

Root : ( ['MQROOT' : 0xaf717e0]
  (0x01000000:Name  ):Properties = ( ['MQPROPERTYPARSER' : 0xdaefb0]
    (0x03000000:NameValue):MessageSet             = '' (CHARACTER)
    (0x03000000:NameValue):MessageType            = '' (CHARACTER)
    (0x03000000:NameValue):MessageFormat          = '' (CHARACTER)
    (0x03000000:NameValue):Encoding               = 546 (INTEGER)
    (0x03000000:NameValue):CodedCharSetId         = 437 (INTEGER)
    (0x03000000:NameValue):Transactional          = TRUE (BOOLEAN)
    (0x03000000:NameValue):Persistence            = FALSE (BOOLEAN)
    (0x03000000:NameValue):CreationTime           = GMTTIMESTAMP '2014-10-01 04:46:46.210' (GMTTIMESTAMP)
    (0x03000000:NameValue):ExpirationTime         = -1 (INTEGER)
    (0x03000000:NameValue):Priority               = 0 (INTEGER)
    (0x03000000:NameValue):ReplyIdentifier        = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):ReplyProtocol          = 'MQ' (CHARACTER)
    (0x03000000:NameValue):Topic                  = NULL
    (0x03000000:NameValue):ContentType            = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceType     = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceToken    = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourcePassword = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceIssuedBy = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedType     = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedToken    = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedPassword = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedIssuedBy = '' (CHARACTER)
  )
  (0x01000000:Name  ):MQMD       = ( ['MQHMD' : 0xdc7880]
    (0x03000000:NameValue):SourceQueue      = 'TEST.IN' (CHARACTER)
    (0x03000000:NameValue):Transactional    = TRUE (BOOLEAN)
    (0x03000000:NameValue):Encoding         = 546 (INTEGER)
    (0x03000000:NameValue):CodedCharSetId   = 437 (INTEGER)
    (0x03000000:NameValue):Format           = '        ' (CHARACTER)
    (0x03000000:NameValue):Version          = 2 (INTEGER)
    (0x03000000:NameValue):Report           = 0 (INTEGER)
    (0x03000000:NameValue):MsgType          = 8 (INTEGER)
    (0x03000000:NameValue):Expiry           = -1 (INTEGER)
    (0x03000000:NameValue):Feedback         = 0 (INTEGER)
    (0x03000000:NameValue):Priority         = 0 (INTEGER)
    (0x03000000:NameValue):Persistence      = 0 (INTEGER)
    (0x03000000:NameValue):MsgId            = X'414d512042524b514d47522020202020ad762b5420004432' (BLOB)
    (0x03000000:NameValue):CorrelId         = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):BackoutCount     = 0 (INTEGER)
    (0x03000000:NameValue):ReplyToQ         = '                                                ' (CHARACTER)
    (0x03000000:NameValue):ReplyToQMgr      = 'BRKQMGR                                         ' (CHARACTER)
    (0x03000000:NameValue):UserIdentifier   = 'SURESH      ' (CHARACTER)
    (0x03000000:NameValue):AccountingToken  = X'1601051500000028d3dcb3b8007357b603f894ec03000000000000000000000b' (BLOB)
    (0x03000000:NameValue):ApplIdentityData = '                                ' (CHARACTER)
    (0x03000000:NameValue):PutApplType      = 11 (INTEGER)
    (0x03000000:NameValue):PutApplName      = 's\SURESH\Desktop\rfhutil.exe' (CHARACTER)
    (0x03000000:NameValue):PutDate          = DATE '2014-10-01' (DATE)
    (0x03000000:NameValue):PutTime          = GMTTIME '04:46:46.210' (GMTTIME)
    (0x03000000:NameValue):ApplOriginData   = '    ' (CHARACTER)
    (0x03000000:NameValue):GroupId          = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):MsgSeqNumber     = 1 (INTEGER)
    (0x03000000:NameValue):Offset           = 0 (INTEGER)
    (0x03000000:NameValue):MsgFlags         = 0 (INTEGER)
    (0x03000000:NameValue):OriginalLength   = -1 (INTEGER)
  )
  (0x01000000:Folder):XMLNSC     = ( ['xmlnsc' : 0xaf1f7a0]
    (0x01000000:Folder):customer = (
      (0x03000000:PCDataField):id   = '1001' (CHARACTER)
      (0x03000000:PCDataField):name = 'NARESH' (CHARACTER)
    )
  )
)

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

_________________
Thanks....
Back to top
View user's profile Send private message
tank_n_spank
PostPosted: Wed Oct 01, 2014 12:19 am    Post subject: Reply with quote

Apprentice

Joined: 02 Sep 2014
Posts: 37
Quote:
[IBM][ODBC Oracle Wire Protocol driver]Optional feature not implemented.' (CHARACTER)


What is the structure of your table, and what types of fields have you got?
Back to top
View user's profile Send private message
MB Developer
PostPosted: Wed Oct 01, 2014 12:40 am    Post subject: Reply with quote

Disciple

Joined: 03 Feb 2014
Posts: 179
Hi tank_n_spank,

This is my table.


CREATE table "CUSTOMER" (
"CUSTOMERID" NVARCHAR2(256),
"FIRSTNAME" NVARCHAR2(256),
"LASTNAME" NVARCHAR2(256),
"TITLE" NVARCHAR2(256),
"DOB" NVARCHAR2(256),
"PHONEHOME" NVARCHAR2(256),
"PHONEWORK" NVARCHAR2(256),
constraint "CUSTOMER_PK" primary key ("CUSTOMERID")
)
_________________
Thanks....
Back to top
View user's profile Send private message
tank_n_spank
PostPosted: Wed Oct 01, 2014 12:43 am    Post subject: Reply with quote

Apprentice

Joined: 02 Sep 2014
Posts: 37
You need to enable N-CHAR Support.
Back to top
View user's profile Send private message
MB Developer
PostPosted: Wed Oct 01, 2014 1:13 am    Post subject: Reply with quote

Disciple

Joined: 03 Feb 2014
Posts: 179
hI tank_n_spank,

I created table like below but now also Select is not working....

CREATE table "NEW_CUSTOMER1" (
"CUSTOMERID" NCHAR(256),
"FIRSTNAME" NCHAR(256),
"LASTNAME" NCHAR(256),
"TITLE" NCHAR(256),
"DOB" NCHAR(256),
"PHONEHOME" NCHAR(256),
"PHONEWORK" NCHAR(256),
constraint "NEW_CUSTOMER1_PK" primary key ("CUSTOMERID")
)



Code:
 2014-10-01 14:40:02.828358

Exception List : ( ['MQROOT' : 0x1174ba0]
  (0x01000000:Name):RecoverableException = (
    (0x03000000:NameValue):File                 = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbComputeNode.cpp' (CHARACTER)
    (0x03000000:NameValue):Line                 = 497 (INTEGER)
    (0x03000000:NameValue):Function             = 'ImbComputeNode::evaluate' (CHARACTER)
    (0x03000000:NameValue):Type                 = 'ComIbmComputeNode' (CHARACTER)
    (0x03000000:NameValue):Name                 = 'Sample_DB_MF#FCMComposite_1_3' (CHARACTER)
    (0x03000000:NameValue):Label                = 'Sample_DB_MF.Compute' (CHARACTER)
    (0x03000000:NameValue):Catalog              = 'BIPmsgs' (CHARACTER)
    (0x03000000:NameValue):Severity             = 3 (INTEGER)
    (0x03000000:NameValue):Number               = 2230 (INTEGER)
    (0x03000000:NameValue):Text                 = 'Caught exception and rethrowing' (CHARACTER)
    (0x01000000:Name     ):Insert               = (
      (0x03000000:NameValue):Type = 14 (INTEGER)
      (0x03000000:NameValue):Text = 'Sample_DB_MF.Compute' (CHARACTER)
    )
    (0x01000000:Name     ):RecoverableException = (
      (0x03000000:NameValue):File              = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp' (CHARACTER)
      (0x03000000:NameValue):Line              = 650 (INTEGER)
      (0x03000000:NameValue):Function          = 'SqlStatementGroup::execute' (CHARACTER)
      (0x03000000:NameValue):Type              = 'ImbESQLManager' (CHARACTER)
      (0x03000000:NameValue):Name              = 'ImbESQLManager' (CHARACTER)
      (0x03000000:NameValue):Label             = 'ImbESQLManager' (CHARACTER)
      (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
      (0x03000000:NameValue):Severity          = 3 (INTEGER)
      (0x03000000:NameValue):Number            = 2488 (INTEGER)
      (0x03000000:NameValue):Text              = 'Error detected, rethrowing' (CHARACTER)
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = '.Sample_DB_MF_Compute.Main' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = '10.4' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = 'SET OutputRoot.XMLNSC.CUSTOMER.CUSTOMERDATA[ ] = DEFAULTPASSTHRU('SELECT * FROM NEW_CUSTOMER1');' (CHARACTER)
      )
      (0x01000000:Name     ):DatabaseException = (
        (0x03000000:NameValue):File              = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
        (0x03000000:NameValue):Line              = 3259 (INTEGER)
        (0x03000000:NameValue):Function          = 'ImbOdbcStatement::checkRcInner' (CHARACTER)
        (0x03000000:NameValue):Type              = '' (CHARACTER)
        (0x03000000:NameValue):Name              = '' (CHARACTER)
        (0x03000000:NameValue):Label             = '' (CHARACTER)
        (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
        (0x03000000:NameValue):Severity          = 3 (INTEGER)
        (0x03000000:NameValue):Number            = 2321 (INTEGER)
        (0x03000000:NameValue):Text              = 'Root SQL exception' (CHARACTER)
        (0x01000000:Name     ):Insert            = (
          (0x03000000:NameValue):Type = 2 (INTEGER)
          (0x03000000:NameValue):Text = '-1' (CHARACTER)
        )
        (0x01000000:Name     ):Insert            = (
          (0x03000000:NameValue):Type = 14 (INTEGER)
          (0x03000000:NameValue):Text = 'odbc32.dll' (CHARACTER)
        )
        (0x01000000:Name     ):DatabaseException = (
          (0x03000000:NameValue):File     = 'F:\build\slot1\S800_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
          (0x03000000:NameValue):Line     = 3437 (INTEGER)
          (0x03000000:NameValue):Function = 'ImbOdbcStatement::checkRcInner' (CHARACTER)
          (0x03000000:NameValue):Type     = '' (CHARACTER)
          (0x03000000:NameValue):Name     = '' (CHARACTER)
          (0x03000000:NameValue):Label    = '' (CHARACTER)
          (0x03000000:NameValue):Catalog  = 'BIPmsgs' (CHARACTER)
          (0x03000000:NameValue):Severity = 3 (INTEGER)
          (0x03000000:NameValue):Number   = 2322 (INTEGER)
          (0x03000000:NameValue):Text     = 'Child SQL exception' (CHARACTER)
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 5 (INTEGER)
            (0x03000000:NameValue):Text = 'HYC00' (CHARACTER)
          )
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 2 (INTEGER)
            (0x03000000:NameValue):Text = '0' (CHARACTER)
          )
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 5 (INTEGER)
            (0x03000000:NameValue):Text = '[IBM][ODBC Oracle Wire Protocol driver]Optional feature not implemented.' (CHARACTER)
          )
        )
      )
    )
  )
)

Root : ( ['MQROOT' : 0x11720b0]
  (0x01000000:Name  ):Properties = ( ['MQPROPERTYPARSER' : 0xb0a18e0]
    (0x03000000:NameValue):MessageSet             = '' (CHARACTER)
    (0x03000000:NameValue):MessageType            = '' (CHARACTER)
    (0x03000000:NameValue):MessageFormat          = '' (CHARACTER)
    (0x03000000:NameValue):Encoding               = 546 (INTEGER)
    (0x03000000:NameValue):CodedCharSetId         = 437 (INTEGER)
    (0x03000000:NameValue):Transactional          = TRUE (BOOLEAN)
    (0x03000000:NameValue):Persistence            = FALSE (BOOLEAN)
    (0x03000000:NameValue):CreationTime           = GMTTIMESTAMP '2014-10-01 09:10:02.820' (GMTTIMESTAMP)
    (0x03000000:NameValue):ExpirationTime         = -1 (INTEGER)
    (0x03000000:NameValue):Priority               = 0 (INTEGER)
    (0x03000000:NameValue):ReplyIdentifier        = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):ReplyProtocol          = 'MQ' (CHARACTER)
    (0x03000000:NameValue):Topic                  = NULL
    (0x03000000:NameValue):ContentType            = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceType     = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceToken    = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourcePassword = '' (CHARACTER)
    (0x03000000:NameValue):IdentitySourceIssuedBy = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedType     = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedToken    = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedPassword = '' (CHARACTER)
    (0x03000000:NameValue):IdentityMappedIssuedBy = '' (CHARACTER)
  )
  (0x01000000:Name  ):MQMD       = ( ['MQHMD' : 0xb0ccb30]
    (0x03000000:NameValue):SourceQueue      = 'TEST.IN' (CHARACTER)
    (0x03000000:NameValue):Transactional    = TRUE (BOOLEAN)
    (0x03000000:NameValue):Encoding         = 546 (INTEGER)
    (0x03000000:NameValue):CodedCharSetId   = 437 (INTEGER)
    (0x03000000:NameValue):Format           = '        ' (CHARACTER)
    (0x03000000:NameValue):Version          = 2 (INTEGER)
    (0x03000000:NameValue):Report           = 0 (INTEGER)
    (0x03000000:NameValue):MsgType          = 8 (INTEGER)
    (0x03000000:NameValue):Expiry           = -1 (INTEGER)
    (0x03000000:NameValue):Feedback         = 0 (INTEGER)
    (0x03000000:NameValue):Priority         = 0 (INTEGER)
    (0x03000000:NameValue):Persistence      = 0 (INTEGER)
    (0x03000000:NameValue):MsgId            = X'414d512042524b514d4752202020202037bd2b542000351d' (BLOB)
    (0x03000000:NameValue):CorrelId         = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):BackoutCount     = 0 (INTEGER)
    (0x03000000:NameValue):ReplyToQ         = '                                                ' (CHARACTER)
    (0x03000000:NameValue):ReplyToQMgr      = 'BRKQMGR                                         ' (CHARACTER)
    (0x03000000:NameValue):UserIdentifier   = 'SURESH      ' (CHARACTER)
    (0x03000000:NameValue):AccountingToken  = X'1601051500000028d3dcb3b8007357b603f894ec03000000000000000000000b' (BLOB)
    (0x03000000:NameValue):ApplIdentityData = '                                ' (CHARACTER)
    (0x03000000:NameValue):PutApplType      = 11 (INTEGER)
    (0x03000000:NameValue):PutApplName      = 's\SURESH\Desktop\rfhutil.exe' (CHARACTER)
    (0x03000000:NameValue):PutDate          = DATE '2014-10-01' (DATE)
    (0x03000000:NameValue):PutTime          = GMTTIME '09:10:02.820' (GMTTIME)
    (0x03000000:NameValue):ApplOriginData   = '    ' (CHARACTER)
    (0x03000000:NameValue):GroupId          = X'000000000000000000000000000000000000000000000000' (BLOB)
    (0x03000000:NameValue):MsgSeqNumber     = 1 (INTEGER)
    (0x03000000:NameValue):Offset           = 0 (INTEGER)
    (0x03000000:NameValue):MsgFlags         = 0 (INTEGER)
    (0x03000000:NameValue):OriginalLength   = -1 (INTEGER)
  )
  (0x01000000:Folder):XMLNSC     = ( ['xmlnsc' : 0x1003360]
    (0x01000000:Folder):EMP = (
      (0x03000000:PCDataField):DEPTNO = '20' (CHARACTER)
    )
  )
) 

_________________
Thanks....
Back to top
View user's profile Send private message
tank_n_spank
PostPosted: Wed Oct 01, 2014 1:23 am    Post subject: Reply with quote

Apprentice

Joined: 02 Sep 2014
Posts: 37
It doesn't matter if you set it to NCHAR or NVARCHAR2, you have to have N-CHAR Support enabled(set to 1).
Code:
EnableNcharSupport=1"
- http://www.mqseries.net/phpBB/viewtopic.php?p=315213&sid=c2b8ccf2a0b967b8e7c1805ad2093c3b
Back to top
View user's profile Send private message
MB Developer
PostPosted: Wed Oct 01, 2014 1:31 am    Post subject: Reply with quote

Disciple

Joined: 03 Feb 2014
Posts: 179
Thanks for quick response tank_n_spank.....
_________________
Thanks....
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database Problem
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.