DSXchange

Check the parameter that you are passing in the seuence.
Check if you the DB is up and running (today i had the same issue, when asked the dba's they said the server was down, later once they ifxed from their side my issue was resolved')

vasubabu wrote:

Mike wrote:Alternatively, change your system password back to the value that it had when you did the installation... if that's possible.

Mike

yes.i have changed the password with the old value.bt still getting the same problem.

Try uninstalling the DS and reinstall again.

Try this, this one always works for me.

list.readu

then make note of the user number,

unlock user <specify userno> unlock all

this will unlock all jobs for any particular user.

chulett wrote:The second log entry for any job shows all environment variables in place at the time the job ran - what does it show there for NLS_LANG?

thanks for helping me find this.

I check that log entry and it shows:

NLS_LANG=AMERICAN_AMERICA.US7ASCII

is this correct ?

And "the character set specified by NLS_LANG" is.... ? I checked the NLS settin in my database (SELECT * FROM NLS_SESSION_PARAMETERS) and its NLSLANGUAGE -----> AMERICAN but Im not sure how to check the NLS in DS. I checked in the oracle stage and it has the following defined in the NLS t...

Hi I know this is common, question but i couldnt understand this issue. I get this warning message in all my jobs (only in paralle), im using the same DS to build server jobs but that didesbt have warnings. but paralle jobs always gives out this message: warning message: main_program: The NLS charac...

Hi Friends, When I am sending data to Rejects file it showing below warning can tell to me how solve this warning. This "LOSGR" Having Decimal Datatype, Size is 13,3. REJECTS: When checking operator: When validating export schema: At field "LOSGR": "null_field" length ...

Setting this environment variable can, as the information you read (and, indeed, posted) about it tells you, prohibit re-import. That's why my preferred approach is not to use this environment variable but to use Null Field Value property values that match the size of the fixed-width field. I did t...

ray.wurlod wrote:Wrap your expression in Code tags, otherwise multiple spaces get compressed by the software. Yes, I mean that you need 19 spaces if the Field Width is 19.

Code: Select all

NullFieldValue = "                   "

That is really awsome. Thanks Ray.

Ray, Just to make sure I understood you or not. you want me to use blank space for the null values? for example if i have a column (creation_date) with date as data type. then in the columns tab of the sequential file stage click on the column number and go to the edit column meta data windo and in ...

Hi I have data in a sequential file, and there are some date fields which are NULL. So i used the APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL to handle null while creating the Seq file, but now when im using this to load the table i get the following warning message. Im not sure why i get this message (...

Use the env variable: (you need to define it in the DS Admin, in user defined section)

APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL

value is TRUE.

Hi I had some problem while loading data into a sequential file, especially in the date fields. The DS Director log gave me lots of warning message and the job was aborting. But later i used the following environment variable and it worked, I was able to supress all the wasrning messages. Warning me...

Could you try double, because we use double data type (dont specify the length, just leave it blank). let me know if still problem exist.

Thank you so much, I fixed the warning message.

I renamed the columns.