Data Job Error

KPUser — Fri, 11 Mar 2016 14:34:44 GMT

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.

Re: Data Job Error

ballardw — Fri, 11 Mar 2016 15:27:43 GMT

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

I suspect that your password wasn't passed correctly.

Re: Data Job Error

KPUser — Fri, 11 Mar 2016 15:39:21 GMT

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">

<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>

<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>

Re: Data Job Error

RonAgresta — Mon, 14 Mar 2016 11:42:26 GMT

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

Re: Data Job Error

KPUser — Mon, 14 Mar 2016 13:31:03 GMT

Perfect. Many thanks Ron.

topic Re: Data Job Error in SAS Data Management

Data Job Error

Re: Data Job Error

Re: Data Job Error

Re: Data Job Error

Re: Data Job Error