nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Failed to start DataDeploy

biss

In an attempt to deploy html template to table in SQL2008 database, following error is being thrown -
=================
DBD: Driver Microsoft SQL Server JDBC Driver 2.0
DBD: Version 2.0.1803.100
DBD: Connected to [:;databasename=]
DBD: Creating identifier mapping table: IWOV_IDMAPS
DBD: CREATE TABLE IWOV_IDMAPS (TYPE INT NOT NULL, SHORTID VARCHAR(30) NOT NULL, LONGID VARCHAR(1024) NOT NULL)
DBD: Created identifier mapping table: IWOV_IDMAPS Successfully
DBD: Creating index on IWOV_IDMAPS
DBD: CREATE TABLE IWDELTRACKER ( PATH VARCHAR(255) NOT NULL , AREA VARCHAR(255) NOT NULL , KEYCOLNAME VARCHAR(255) NOT NULL , KEYCOLVALUE VARCHAR(255) NOT NULL )
DBD: CREATE INDEX iwdelt_idx ON IWDELTRACKER( PATH , AREA )
DBD: IWDELTRACKER created successfully.
DBD: ERROR:Error: Failed to start DataDeploy
=============

Other relevant configurations are intact; say,
(1) DATADEPLOY=true in OD.lic file
(2) Datadeploy is set and uncomment in the odbase.xml file

Has anyone come across such scenario, could share the resolution approach. Any help in addressing the issue is much appreciated.

Find more posts tagged with

Comments

Adam Stoller

Has DD ever worked for you there - or is this the first time you're attempting to make it work there?

You say

Other relevant configurations are intact; say,
(1) DATADEPLOY=true in OD.lic file
(2) Datadeploy is set and uncomment in the odbase.xml file

After you uncommented the section in the odbase.xml file - did you restart the OpenDeploy service?

biss

Hi,Thank you for posting.
This the first time I'm attempting to make it work in this server; OD works seamlessly, thou.
OD service was restarted after the change in odbase.xml

Adam Stoller

Try stopping and restarting the OpenDeploy service again, and then examine closely the contents of the ODHOME/od.log and ODHOME/log/hostname_odbase.log looking for any and all references to DataDeploy

biss

Restarted OD service; no luck. Only error logged is "Failed to start Data Deploy". Do you think this error might be due to (1) Data Deploy configuration [odbase.xml and OD.lic]; (2) incorrect formation of datadeploy configuration in /od-home/conf/
Or, any other possible reason?

Adam Stoller

Restarted OD service; no luck. Only error logged is "Failed to start Data Deploy". Do you think this error might be due to (1) Data Deploy configuration [odbase.xml and OD.lic]; (2) incorrect formation of datadeploy configuration in /od-home/conf/
Or, any other possible reason?

Can you post the od.log portion from the re-starting of the service?

biss

PFA requested log

Adam Stoller

Well, the good news is that OD recognized that DataDeploy was enabled

...
#Thu Feb 19 09:51:56 PST 2009
[...]
DATADEPLOY=true
[...]
--Permanent License --
License Information
[...]
  Platform            : SunOS
  O/S version         : null
 DataDeploy          : true
...

The bad news is you seem to have a lot of socket errors:

...
2012-10-04 ... odLog [OpenDeploy Main] - LIB: (2) Bound to interface(rds09470cms21) port (57100)
2012-10-04 ... odLog [DDThread] - DD Home : /iw-home/OpenDeployNG
OpenDeploy server and its RMI registry started.
2012-10-05 ... odLog [...] - ERROR: recv failure, err=131 [Unknown socket error]
2012-10-05 ... odLog [...] - IWDeploySock::ReadLineWithLength ERROR: Failed to read length of data buffer from socket.
2012-10-05 ... odLog [...] - IWDeploySock::ReadLine ERROR: Failed to read (-1) bytes of data from socket.
2012-10-05 ... odLog [...] - ERROR: send failure, err=32 [Unknown socket error]
2012-10-05 ... odLog [...] - IWDeploySock::WriteLongLine ERROR: Sending length of data buffer to remote.
2012-10-05 ... odLog [...] - IWDeploySock::ReadLongLine ERROR: No response data from remote.
2012-10-05 ... odLog [...] - ERROR: send failure, err=32 [Unknown socket error]
...

I'm not sure they're directly related - but you probably need to check those out - perhaps port 57100 is not a good port, or there's some other port in conflict with some other software running on the server...

mart2001

You should also check that server which OD resides can talk to the server that the DB resides and the ports are open. Can you do a telnet DBServer port and do you get a response? Are there firewalls blocking communications between the two servers?

biss

While investigating further, I notice the following in deployment log -
"DBD: Driver Microsoft SQL Server JDBC Driver 2.0"

Various technical forums say that "The Microsoft SQL Server JDBC Driver version 2.0 can connect to SQL Server 2008 but does not fully support the new data types or other features that are new in SQL Server 2008"

Driver version 3.0 or 4.0 is fully compatible with SQL Server 2008. As per the instruction in "od_71_ref_v01_en.pdf" I have downloaded the Driver version 4.0 from "http://msdn.microsoft.com/downloads/"; however, while untaring the downloaded file in Solaris server, "directory checksum error" is being thrown. Same is the error with Driver version 3.0 file.

Has anyone experienced such an issue and the way forward?

Adam Stoller

Sounds like there's an issue with either the site you are downloading from, the manner in which the file is being downloaded (like downloading a binary in ascii mode from an FTP site)

biss

I have got another query;
The DB table structure has got a column of datatype 'varbinary' that allows-null; however, in my DataDeploy configuration I have excluded that column, as DataDeploy does not support varbinary data-type in SQL Server database.

Does DataDeploy validate all columns in a table structure or only the ones captured in ? The question arises, as I am clueless whether logically a varbinary data-type column fails DataDeploy to start.

Adam Stoller

I have got another query;
The DB table structure has got a column of datatype 'varbinary' that allows-null; however, in my DataDeploy configuration I have excluded that column, as DataDeploy does not support varbinary data-type in SQL Server database.

Does DataDeploy validate all columns in a table structure or only the ones captured in ? The question arises, as I am clueless whether logically a varbinary data-type column fails DataDeploy to start.

I believe you should be okay as long as the column isn't referenced anywhere within the DD config file and the DB allows that column to be null.