top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Database driver error >>The character “ ” following “ÃãÉåÉãèmÉÄ@” is not valid<< during session execution

0 votes
186 views

I am getting below error at session level. kindly help me to fix this -

READER_1_1_1> RR_4035 SQL Error [
[IBM][CLI Driver][DB2/AIX64] SQL0007N The character " " following "ÃãÉåÉãèmÉÄ@" is not valid.
SQLSTATE=42601
sqlstate = 42601
Database driver error...

I have written a SQL query in source qualifier. Query is fetching data from three tables, so join is there,condition is there and sub-query is also. While validating in source qualifier, it not giving any error and even running this query in toad, it is running fine.

So why I am getting this error at session level? Is it because query has sub-queries or some connection issues with DB?

My DB is DB2.

posted Jul 10, 2014 by Sachin

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+4 votes

I'm using Bulk Export/ Import Extension in OpenCart .export is working well but,when import file Error:Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

+2 votes

I'm trying to load within an Oracle XE 10g database. When I run an Informatica PowerCenter Workflow, I get a following error:

CMN_1022    Database driver error...
CMN_1022 [Database driver event...Error occurred loading library [pmora8.dll]. System error encountered is 193. Error text is %1 is not a valid Win32 application.
.]

Any ideas what might be causing this error? My environment is as follows:
•Windows Server 2008 R2
•Informatica PowerCenter 9.5
•Oracle XE 10 G

Powercenter repository is on SQL Server 2012.

+1 vote

Redirection (3xx), Client failure (4xx), Server failure (5xx) and Global failure (6xx) in which scenarios these codes are used ?

+1 vote

The windows phone emulator wasn't able to ensure the virtual machine was running
Something happened while starting a virtual machine: Emulator WVGA 512MB. Could not initilize.
Not enough memory in the system to start virtual machine Emulator WVGA 512.MB XXXXXXX with ram size 512 megabytes

Any give me a appropriate solution to resolve this.

...