Page History
...
<rowsets>
<error>
<code>9100</code>
<description>ERROR at statement 72000</description>
<external-code>1034</external-code>
<external-description>ORA-01034: ORACLE not available</external-description>
</error>
</rowsets>
Load Request Example
Info |
---|
Do NOT enter blanks, nor new lines between the tags. |
The following example presents a request to load data.
<rowsets connection-pool=”pw”><!-- the connection pool names should always be "pw" -->
<rowset object="PW_NTAC_ACTIONS_T" single-commit="true"> <!--table name and indication to commit only after all rows are loaded into PW -->
<columns> <!-- the list of columns should be kept in the rows creation -->
<column>NTAC_TIMESTAMP</column>
<column>NTAC_ID1</column>
<column>NTAC_CONSUMER_IP</column>
<column>NTAC_REQUESTS_SUM</column>
<column>NTAC_NETWORK_TIME_SUM</column>
<column>NTAC_TIME1_SUM</column>
<column>NTAC_STAT1_SUM</column>
<column>NTAC_STAT2_SUM</column>
<column>NTAC_SOURCE_ID</column>
<column>NTAC_PWII_INSTANCE_ID</column>
<column>NTAC_INSTANCE</column>
<column>NTAC_SERVER</column>
<column>NTAC_INSTANCE_GID</column>
<column>NTAC_SERVER_GID</column>
<column>NTAC_CONSUMER_IP_GID</column>
<column>NTAC_RED_SUM</column>
<column>NTAC_YELLOW_SUM</column>
<column>NTAC_GREEN_SUM</column>
</columns>
<row rownum="1"><![CDATA[2212003-08-2811:30:00.0^21010.1.0.218^1910.1.1.94^17175.000^1621.600^150.000^1514963^1820227220^12SQ^141009^210SAPSQLSRV2^210sapsqlsrv2^0^0^0^130.0^130.0^130.0^]]></row>
<row rownum="2"><![CDATA[2212003-08-2811:30:00.0^21010.1.0.218^1910.1.1.94^17175.000^1621.600^150.000^1514963^1820227220^12SQ^141009^210SAPSQLSRV2^210sapsqlsrv2^0^0^0^130.0^130.0^130.0^]]></row>
</rowset>
</rowsets>