DataDeploy error

cdoloriert

Hi,

I've been trying to call a SP from a datadeploy configuration file and it works fine the first time it runs, but it fails the second time. I think is related to the primary key, however, when I execute the same SP in management studio is works fine.


ENG: 2009-09-10 13:45:12 EDT GMT-04:00 Begin logfile [C:\Applications\Interwoven\OpenDeployNG\log\Monitor/datadeploy/integration\src.MarketingContent_dd.storedproc1.CAM-ITS-DEV.to.database.log] ---------
ENG: 2009-09-10 13:45:12 EDT GMT-04:00 Job ID=m58 Deployment=Monitor/datadeploy/integration/MarketingContent_dd
ENG: 2009-09-10 13:45:12 EDT GMT-04:00 DataDeploy Version is 6.1.1.0.0
ENG: 2009-09-10 13:45:12 EDT GMT-04:00 Owner started the deployment is CAM-ITS-DEV\tsadminuser
ENG: 2009-09-10 13:45:12 EDT GMT-04:00 DD args iwdd="storedproc1" assetPath="imported/Monitordotcom/images/lilies.jpg" assetTypeID="2" iwdd-op="do-sql" user-op="execute_my_procedure1" assetID="960F21B4-9785-4467-9469-46C7D8CFA80C" database="MonitorGermanyInt" assetSize="51144" cfg=C:\Applications\Interwoven\OpenDeployNG\conf\Monitor/datadeploy/integration\MarketingContent_dd.xml need-result=yes depuuid=b0cca000-9e31-11de-8108-ea84401af95d leglabel=database

ENG: 2009-09-10 13:45:12 EDT GMT-04:00 Proceed to execute the database deployment

DBD: Deployment : storedproc1
DBD: Database Vendor set to rdbms
DBD: Max Identifier length set to 128 characters.
DBD: [Thu Sep 10 13:45:12 EDT 2009] Begin executing storedproc1
DBD: Setting up consumer TDbAgent
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [MUM-SQL-TEST1:1433;databaseName=MonitorGermanyInt]
DBD: iwdd-op=do-sql
DBD: SQL : = exec dbo.Mon_CheckAssetInfo '960F21B4-9785-4467-9469-46C7D8CFA80C', 2, 'imported/Monitordotcom/images/lilies.jpg', 51144
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Rollback database [MUM-SQL-TEST1:1433;databaseName=MonitorGermanyInt]...
DBD: Deployment[storedproc1] Table[NO_TABLE_NEEDED]
DBD: -----------------------------------
DBD: Tuples inserted : 0
DBD: Tuples updated : 0
DBD: Tuples deleted : 0
DBD: Tuples failed : 0
DBD: Tuples rolled back : 0
DBD: Tuples skipped : 0
DBD: -----------------------------------
DBD: Started : Thu Sep 10 13:45:12 EDT 2009
DBD: Finished: Thu Sep 10 13:45:13 EDT 2009
DBD:
### IWDataDeploy FAILED ###

DBD:
### Sending result ###

ENG: 2009-09-10 13:45:13 EDT GMT-04:00 Database deployment execution returned 1

ENG: 2009-09-10 13:45:13 EDT GMT-04:00 <<< Completed database deployment Invocation>>>

ENG: 2009-09-10 13:45:13 EDT GMT-04:00 Job ID=m58 Deployment leg=database Elapsed Time=1078 ms <<<
ENG: 2009-09-10 13:45:13 EDT GMT-04:00 End logfile [C:\Applications\Interwoven\OpenDeployNG\log\Monitor/datadeploy/integration\src.MarketingContent_dd.storedproc1.CAM-ITS-DEV.to.database.log]


The SP is



ALTER PROCEDURE [dbo].[Mon_CheckAssetInfo]
(
@AssetID NVARCHAR(100),
@AssetTypeID INT,
@AssetPath NVARCHAR(MAX),
@AssetSize NVARCHAR(50)
)
AS


***************************************************************************************************************/
BEGIN
--SET NOCOUNT ON

BEGIN TRAN

IF NOT EXISTS(SELECT 1 FROM MON_ASSETINFO WHERE ASSETID = @AssetID)
INSERT INTO MON_ASSETINFO (ASSETID,ASSETTYPEID,ASSETPATH,ASSETSIZE)
VALUES (@AssetID, @AssetTypeID, @AssetPath, @AssetSize)
@ERROR <> 0 GOTO ERROR_HANDLER

COMMIT TRAN

ERROR_HANDLER:
@ERROR <> 0
BEGIN
RAISERROR ('an error encountered while performing the operation', 16, 1)
--SET @Result = -1
@TRANCOUNT > 0 ROLLBACK TRAN
RETURN
END

--SET NOCOUNT OFF
END



Any advice on this issue?

Thanks in advance.

cdoloriert

Hi,

I just want to run an execute stored procedure, my dd file is bellow:


[PHP]












exec dbo.Mon_CheckAssetInfo '$assetID^', $assetTypeID^, '$assetPath^', $assetSize^










[/PHP]

Am I missing something here?
I tried to replace type="exec-proc", but I got a null pointer exception.
Any suggestions?

Thanks in advance.