Invalid Object Name

This error results from the table not being found for the subscriber and product or project.

 

SUBMITTED

<ibdoc>

	<datarequest project_id="1" env_def="Production">

		<program parent_id="8647" id="29" ver="1" datemask='mm/dd/yyyy'>

			<m i="4" r="1" n="BI Territory Factor" product_id="101"/>

			<m i="4" r="1" p="5" c="2" n="PD Territory Code" product_id="101">

			<q i="1" t="0" v="8" o="="/>

			<q i="1" t="0" v="11" o="="/> 

			</m>

		</program>

	</datarequest>

</ibdoc>

 

RETURNED

<ibdoc gen_date="3/29/2015 7:30 PM" timespan="0.078125" site_location="DB001"><dataresults project_id="1" env_def="production"><program parent_id="8647" id="5" ver="1"><error>System.Data.SqlClient.SqlException: Invalid object name 'DT18647'.</error></program></dataresults></ibdoc>

In this example a request was made against the auto line in the “Production” environment. When the query was made, the requested table could not be found. To correct the error in this example, verify that the package has been loaded to the proper environment and that the correct subscriber and product or projects were used.

<program parent_id="8659" id="29" ver="1" datemask='mm/dd/yyyy'>