Data Job Error

[KPUser]

I am attempting to run a data job but keep getting the following error:

1: [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied

I enter the oracle ODBC password before this when I set up the job and I could connect fine.  Any help would be appreicated.

[ballardw · Accepted solution]

Post the code you are using to attempt the connection and the full log.

I suspect that your password wasn't passed correctly.

[KPUser]

I'm using a ODBC data source so no code required.  The full log states:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<datafluxdocument class="architectjob" version="1.2">

  <jobid id="56E2AD7D389585E9"/>

  <propset>
    <prop name="_DESCRIPTION">
      <value dtype="String"></value>
    </prop>
    <prop name="_NOTES">
      <value dtype="String"></value>
    </prop>
    <prop name="AutoLayoutRequired"/>
    <prop name="DefaultLayout">
      <value dtype="String">LeftToRight</value>
    </prop>
    <prop name="GroupNodes"/>
    <prop name="name">
      <value dtype="String">Test Data Job</value>
    </prop>
    <prop name="ShowGridLines">
      <value dtype="String">True</value>
    </prop>
    <prop name="SnapToGrid">
      <value dtype="String">False</value>
    </prop>
    <prop name="STICKYNOTES"/>
    <prop name="ZoomLevel">
      <value dtype="String">26</value>
    </prop>
  </propset>

  <paramset>
    <param name="WFINPUTS" type="matrix"/>
    <param name="WFOUTPUTS" type="matrix"/>
  </paramset>

  <page>
    <propset>
      <prop name="serial_targets"/>
    </propset>
    <step id="SOURCE_ODBCSQL" iid="2" ver="1">
      <propset>
        <prop name="color"/>
        <prop name="default_target"/>
        <prop name="description">
          <value dtype="String">SQL Query 1</value>
        </prop>
        <prop name="descriptive_text">
          <value dtype="String">Specifies an SQL query that selects data from one or more tables. The results table is used as an input in a data job</value>
        </prop>
        <prop name="node_position">
          <value dtype="String">146.4</value>
          <value dtype="String">238.761875</value>
        </prop>
        <prop name="notes">
          <value dtype="String"></value>
        </prop>
        <prop name="serial_target_position"/>
      </propset>
      <paramset>
        <param dtype="String" name="DSN" type="single">DSN=PSELIV01_USER;DFXTYPE=ODBC</param>
        <param dtype="Unknown" isnull="true" name="MAX_OUTPUT_ROWS" type="single"></param>
        <param dtype="String" name="SQL_STMT" type="single">SELECT GENDER FROM PERSON</param>
        <param name="SQL_PARAMETERS" type="matrix"/>
        <param dtype="Unknown" isnull="true" name="ROW_ESTIMATE" type="single"></param>
        <param dtype="Unknown" isnull="true" name="SQL_PROTOTYPE" type="single"></param>
        <param name="TYPE_OVERRIDES" type="matrix"/>
        <param dtype="Unknown" isnull="true" name="POOL_NAME" type="single"></param>
      </paramset>
    </step>
  </page>

</datafluxdocument>

[RonAgresta]

Hi,

It appears you are building a data job in Data Management Studio. If you haven't already done so, try going to the "Data" riser on the left in Data Management Studio, right-click on your "PSELIV01_USER" data connection, clear and then save your user credentials.

Ron

[KPUser]

Perfect.  Many thanks Ron.