BizTalk Server - Biztalk SQL Exception error

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > April 2006 > Biztalk SQL Exception error





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Biztalk SQL Exception error
sozden

2006-04-27, 7:25 am

Hi,
I am new on Biztalk. I installed BTS2006 trial version. I create some
schemas and maps. That's ok. But when i try to create a port, i can't
create port location. Because pipeline dropdown list is empty. So i try
to create pipeline firstly. That's ok. When i build my application
there is no error. But when i deploy the project i am taking some
errors:
Is it possible from configuration? What do you think.

In the following lines, I pasted error screen

Could you help me?
Thanks

****************************************
ERROR DESCRIPTION
**************
------ Build started: Project: BatchProcess, Configuration: Deployment
..NET ------
Updating references...
Performing main compilation...

The project is up-to-date.
------ Deploy started: Project: BatchProcess, Configuration: Deployment
..NET ------
Deploying...
: VSDEPLOY: ApplicationName="Batchapp", Assembly="C:\Documents and
Settings\Administrator\Desktop\biztalk\o
rnek\BizEnvelop_src\BizEnvelop_src\bin\D
eployment\BatchProcess.dll",
Install=True, Redeploy=False.

: Solution "C:\Documents and
Settings\Administrator\Desktop\biztalk\o
rnek\BizEnvelop_src\BizEnvelop_src\Batch
Process.sln":
* BatchProcess, Version=1.0.0.1

: Adding resource (-Type="System.BizTalk:BizTalkAssembly"
-Luid="BatchProcess, Version=1.0.0.1, Culture=neutral,
PublicKeyToken=534a324d8c2a6e2e") to application "Batchapp"...

: Validating resources (count=1)...

: Performing change requests...

: Calling BeginTypeChangeRequest for all selected resource types...

: * Performing change request on type
"System.BizTalk:BizTalkAssembly" (count=1)...

: Deploy server="(LOCAL)" database="BizTalkMgmtDb"
assembly="C:\Documents and Settings\Administrator\Local
Settings\Temp\BT\PID2476\BizTalkAssembly
\7d19ce4cc11dae94938563bb2fd02e1a\BatchP
rocess.dll"

error DEPLOY: SQL exception: "Could not find stored procedure
'dtasp_InsertService'."

: PerformingEndChangeRequestsWithRollBack

error DEPLOY: Failed to add resource(s). Change requests failed for
some resources. BizTalkAssemblyResourceManager failed to complete end
type change request. SQL exception: "Could not find stored procedure
'dtasp_InsertService'."

BatchProcess - 2 error(s), 0 warning(s)
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com