running a job issue with ole db connections

Hi,

Got another question. I run my job and it runs the first two steps fine but when I hit the third step i get an error. In the third step I have an ole db connection to an AS400 db and downloading data from it. Is there any way that I can get this to read and accept the ole db connection because it seems like it doesn't recognize it.

Thanks

Brian

What is the third step? A task of some sort? What kind of task- what object did you drag onto the surface?

Donald Farmer

sql

Run time error: out-of-range datetime value

Hi everyone, this is the exception:

System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

Here's my code!

... 'datagrid code
cmdSelect.CommandText = "SELECT * FROM [Table] WHERE [Date and Time] > '" & Me.tbFromDate.Text & "' AND [Date and Time] < '" & Me.tbToDate.Text & "'"
...

Me.tbFromDate.Text and Me.tbFromDate.text look like this: 27/11/2003 1:11:43 PM

The SQL Query works fine - just that this code gives a runtime error.

Can someone help?? I'm guessing I have to do somekind of conversion!!

AndrewDoes your sql query work fine with 27/11/2003 1:11:43 PM
or 11/27/2003 1:11:43 PM

While checking the date Try DateTime.Parse<your date>)

run time error: Encountered the symbol "S" when expecting one of the following:

ocasionally, in the testing environment we receive following error:
(we using Oracle 9i), error is reported by the EXCEPTION
WHEN OTHERS THEN (see below)

upon logging ad posting status for 250
Normal -6550 ORA-06550: line 4, column 308:
PLS-00103:
Encountered the symbol "S" when expecting one of the following:
. ( ) , * @. % & | = - + < / > at in is mod not range rem => .. <>
or != or ~= >= <= <> and or like between ||
************************************************** *******

I am providing a complete PL/SQL, this error only occurs at the run-time

PROCEDURE logPostingStatus(p_session_id IN NUMBER,
p_person_id IN NUMBER,
p_ad_id IN NUMBER,
p_production IN VARCHAR2 DEFAULT 'y',
p_status IN VARCHAR2 DEFAULT 'started',
p_files IN VARCHAR2 DEFAULT null,
p_note IN VARCHAR2 DEFAULT null,
p_site_profile_id IN NUMBER DEFAULT -1,
p_site_id IN NUMBER DEFAULT -1)
AS

v_posted_before DATE;
v_change_type VARCHAR2(32);
v_job_num NUMBER;

v_files_passed VARCHAR2(2048) DEFAULT replace(ltrim(rtrim(p_files)), ',', '<br>');
v_files_just_pushed VARCHAR2(2048);
v_files_pushed_before VARCHAR2(2048);
v_files_to_purge VARCHAR2(2048);
v_filename VARCHAR2(256);
v_status VARCHAR2(16) DEFAULT p_status; -- the new status
v_pos NUMBER;
v_phase VARCHAR2(16);

BEGIN

UPDATE ad_post_status
SET end_time = SYSDATE,
-- update the status in the posting status, repeating status => ended
status = decode(status, 'aborted', 'aborted',
lower(p_status), 'ended',
lower(p_status)),
-- append the files pushed by this thread.
files_pushed = decode(files_pushed, null, v_files_passed,
files_pushed || '<br>' || v_files_passed),
note = decode(note, null, p_note, note || '. ' || p_note)
WHERE session_id = p_session_id and ad_id = p_ad_id and production = p_production
RETURNING files_pushed, status INTO v_files_just_pushed, v_status;
-- files_pushed now holds the files pushed by the both threads
-- v_status is the new status

IF (SQL%ROWCOUNT = 0) THEN

-- no log exists for the job yet: we are starting a new job (status will be
-- 'started', the column default)
INSERT INTO ad_post_status (session_id, ad_id, production, note, initiated_by)
VALUES(p_session_id, p_ad_id, p_production, p_note, p_person_id);

END IF;

-- log the session ID in the site/site profile if it is site/site profile roll-out
IF (p_site_profile_id > 0) THEN

UPDATE site_profile
SET roll_session = p_session_id
WHERE site_profile_id = p_site_profile_id and roll_session is null;

ELSIF (p_site_id > 0) THEN

UPDATE site
SET roll_session = p_session_id
WHERE site_id = p_site_id and roll_session is null;

END IF;

-- if two threads complete successfully ...
IF (v_status = 'ended') THEN

-- update posting time
IF (p_production <> 'y') THEN

UPDATE ad SET posted_preview = SYSDATE where ad_id = p_ad_id;

ELSE

SELECT posted_production, change_type
INTO v_posted_before, v_change_type
FROM ad
WHERE ad_id = p_ad_id;

-- ad descriptor_status: off (non-deleted) -> on
UPDATE ad SET descriptor_status = 'on',
dtor_status_modified_by = p_person_id,
dtor_status_modified_reason = 'ad approved and files pushed sucessfully'
WHERE ad_id = p_ad_id
AND status not in ('deleted','failed')
AND descriptor_status = 'off';

-- ad status pending -> live
UPDATE ad SET status = 'live',
status_modified_by = p_person_id,
status_modified_reason = 'ad approved and files pushed successfully'
WHERE ad_id = p_ad_id AND status = 'pending';

UPDATE ad SET posted_production = SYSDATE,
change_type = null
WHERE ad_id = p_ad_id;

-- decrement the live ad count as we are rolling out site profile changes
IF (p_site_profile_id > 0) THEN

UPDATE site_profile
SET roll_ad_count_rolled = roll_ad_count_rolled + 1,
roll_session = p_session_id,
status_modified_by = p_person_id
WHERE site_profile_id = p_site_profile_id;

ELSIF (p_site_id > 0) THEN

UPDATE site
SET roll_ad_count_rolled = roll_ad_count_rolled + 1,
roll_session = p_session_id,
status_modified_by = p_person_id
WHERE site_id = p_site_id;

END IF;

-- send traffic reminder email in 24 hours if the ad was approved not for the first time
-- (and not trafficed in 24 hours)
IF (v_posted_before is not null and instr(v_change_type, 'T') > 0) THEN

DBMS_JOB.SUBMIT(v_job_num,
'notify.trafficReminder(' || p_ad_id || ',' || p_person_id || ');',
SYSDATE + 1);

END IF;

/*
* handle akamai file purge: store the files to be pushed;
* detect if there is any file that needs to be purged,
* if yes, send reminder email
*/

v_files_to_purge := '';

IF (v_files_just_pushed || '' = '') THEN
UPDATE ad_post_status
SET files_pushed = '(no file to push)'
WHERE session_id = p_session_id and ad_id = p_ad_id and production = p_production;
RETURN;
END IF;

BEGIN
-- files just pushed
SELECT value INTO v_files_pushed_before
FROM ad_prop
WHERE ad_id = p_ad_id AND name = 'files_pushed';

-- find files to be purged, e.g., files that are passed from p_files and already
-- in the ad_prop 'files_pushed'
LOOP
-- parse the filenames from files_pushed
EXIT WHEN (length(v_files_just_pushed || 'x') = 1);
v_pos := instr( v_files_just_pushed, '<br>' );
IF (nvl(v_pos, 0) = 0) THEN
v_pos := length(v_files_just_pushed) + 1;
END IF;

v_filename := ltrim(rtrim(substr(v_files_just_pushed,1,v_pos-1)));

IF (length(v_filename) > 0) THEN
IF (instr(v_files_pushed_before, v_filename) <= 0) THEN
UPDATE ad_prop
SET value = value || '<br>' || v_filename
WHERE ad_id = p_ad_id
AND name = 'files_pushed';
ELSE
-- the string @.@. is used as a place-holder for the site tag file path
-- the string !! is used as a place-holder for the ad file path
-- the string ## is used for the creative (generic) file path
IF (instr(v_filename, '_sitetag.txt') > 0) THEN
v_files_to_purge := v_files_to_purge || '..@.@.' || v_filename;
ELSIF (instr(v_filename, 'SiteId_') = 1) THEN
v_files_to_purge := v_files_to_purge || '..!!' || v_filename;
ELSE
v_files_to_purge := v_files_to_purge || '..##' || v_filename;
END IF;
END IF;
END IF;
-- jump over the delimiter <br>
v_files_just_pushed := substr( v_files_just_pushed, v_pos+4 );

END LOOP;

-- notify of files to be purged
IF (v_files_to_purge || 'x' <> 'x') THEN
notify.filesToPurge(p_ad_id, v_files_to_purge, p_person_id, p_site_profile_id, p_site_id);
END IF;

EXCEPTION
WHEN NO_DATA_FOUND THEN
-- no file has been pushed before: insert the ad_prop
INSERT INTO ad_prop (ad_id, type, name, value)
VALUES(p_ad_id, '-', 'files_pushed', v_files_just_pushed);

END;

END IF;

ELSIF (v_status = 'aborted') THEN

-- determine phase to be written into error notification
IF (p_production = 'y') THEN
v_phase := 'production';
ELSE
v_phase := 'live preview';
END IF;

-- decrement the live ad count as we are rolling out site profile changes
IF (p_site_profile_id > 0) THEN

UPDATE site_profile
SET roll_ad_count_rolled = roll_ad_count_rolled + 1,
roll_session = p_session_id,
status_modified_by = p_person_id
WHERE site_profile_id = p_site_profile_id
AND roll_ad_count > 0;

ELSIF (p_site_id > 0) THEN

UPDATE site
SET roll_ad_count_rolled = roll_ad_count_rolled + 1,
roll_session = p_session_id,
status_modified_by = p_person_id
WHERE site_id = p_site_id
AND roll_ad_count > 0;

END IF;

notify.postError(p_ad_id, p_person_id, p_site_profile_id, p_site_id, v_phase, p_note);

END IF;

EXCEPTION
WHEN OTHERS THEN
library.logError('upon logging ad posting status for ' || to_char(p_ad_id));
--raise_application_error( -20002, 'logging ad posting status failed');

END logPostingStatus;I can't see where the error is coming from, but try this: comment out (or remove) all the exception handling:

--EXCEPTION
--WHEN OTHERS THEN
--library.logError('upon logging ad posting status for ' || to_char(p_ad_id));

Then the error message will inform you of precisely which line of code the error occured on.

One error I did spot (but is irrelevant to your problem):

IF (v_files_just_pushed || '' = '') THEN

This will never be true, because in Oracle '' is equivalent to NULL, and NULL = NULL is never true. Your test should be:

IF v_files_just_pushed IS NULL THENsql

run time error 3265 after moving from Sql servr 7 to sql server 20

Hopefully somebody see the mistake I am doing.
We are using an Vb application connecting to SQL 7. After moving to SQL 2000
and Windows 2000 system the same application send error message when trying
to insert or update any data via the VB application. What did I missied to
transfer?
I try to move the application via the Copy wizard and also via data import
and both had same result. I also checked the security settings on the old
server and the new one.
Thanks Katja
What exactly are you doing when you get the error?
Andrew J. Kelly SQL MVP
"Katja J." <Katja J.@.discussions.microsoft.com> wrote in message
news:8ABAEC7E-CB87-415F-9066-D19340ED688B@.microsoft.com...
> Hopefully somebody see the mistake I am doing.
> We are using an Vb application connecting to SQL 7. After moving to SQL
> 2000
> and Windows 2000 system the same application send error message when
> trying
> to insert or update any data via the VB application. What did I missied to
> transfer?
> I try to move the application via the Copy wizard and also via data import
> and both had same result. I also checked the security settings on the old
> server and the new one.
> Thanks Katja

Run Time Error '-2147467259(80004005)':

WE have couple of applications using sql and were working
till friday 01/02/04. This morning when users are trying
to access it giveing the error Run Time Error '-2147467259
(80004005)':
Invalid connection String.
Any Idea.
Application connects to 2 sql 6.5 servers and 1 sql 2000
server. I changed the TCP/Ip ports on one of the server
in server network Utility to 1521 and changed it back to
1433 . nothing else. has changed as far as I can think
of.. please help THanks in advanceReply back with the connection string syntax.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

run time error

I create an application with Visual Basic 6 and Crystal Report 10
with IDE Environment.While Developing the application it works fine
in my system.but after i made the application
setup, and when while I am deploying (install)the application
in the same system (widows xp) it show run time error. i ignore the
error and continue the installiation till the end.
and then when i run the application it works ok but when i use print
command it show error(crviewer file not found). and the application
closed.so what is the problem here.please help
to solve it.

thanksEither you have not included the crviewer.dll file in your setup package or there might have been a problem while copying/registering the file. Try registering the File manually using regsvr32.

Run Time Database Connection

Hi
I 've created dsn for sqlserver during run time but while connecting with crystalreport it gives ODBC Error . I need to connect using CRAXDRT.Report,CRAXDRT.Application ,I'm Using vb as front end
Thanks In AdvGenerall the errors are descriptive, so please provide details on which ODBC error it is.

Dave
(Me.HomeTown = DarrenLehmann.HomeTown)
Go Aussies.|||Hi Spring soft

I solved my problem thanx for ur post|||Hi Tony,
Perhaps you could let us know the solution, for enlightenment of others.
On reflection, I suspect the report had a subreport. That's the most common reason (apart from improperly structured formulae) that raises ODBC errors.

Dave|||Ofcourse dave

Private m_crxApp As New CRAXDRT.Application
Private m_crxRep As CRAXDRT.Report
Attribute m_crxRep.VB_VarHelpID = -1
Private m_crxTab As CRAXDRT.DatabaseTable
Implements clsSimpleReport
Public Function clsSimpleReport_RunReport(sReportFileName As String, sTitle As String) As Variant
Dim i As Integer, j As Integer
On Error Resume Next
Screen.MousePointer = 11
m_crxApp.LogOnServer "p2sodbc.dll", "DSN", "DBNAME, "UID", "PWD"
Set m_crxRep = m_crxApp.OpenReport(App.Path & "\Reports\" & sReportFileName)
crvReport.ReportSource = m_crxRep
crvReport.ViewReport
End sub

My mistake was instead of p2sodbc.dll in logon server function i put some other dll file i'm not remembering that nowsql

Run SQL2k SE 32-bit on 64-bit machine?

Is this possible? If so, are there any OS configurations that need to be se
t
ahead of time? When attempting to install, I am getting an error that says:
The image file autorun.exe is valid, but for a machine type other than the
current machine.
Thanks!Try running setup ipv autorun; autorun is likely a 16 bit app, which
will not run on x64.
Mitch wrote:
> Is this possible? If so, are there any OS configurations that need to be
set
> ahead of time? When attempting to install, I am getting an error that say
s:
> The image file autorun.exe is valid, but for a machine type other than the
> current machine.
> Thanks!

Run SQL2k SE 32-bit on 64-bit machine?

Is this possible? If so, are there any OS configurations that need to be set
ahead of time? When attempting to install, I am getting an error that says:
The image file autorun.exe is valid, but for a machine type other than the
current machine.
Thanks!Try running setup ipv autorun; autorun is likely a 16 bit app, which
will not run on x64.
Mitch wrote:
> Is this possible? If so, are there any OS configurations that need to be set
> ahead of time? When attempting to install, I am getting an error that says:
> The image file autorun.exe is valid, but for a machine type other than the
> current machine.
> Thanks!

run MDX query in SQL Server Agent issue

Hello,

We have 'Create global cube' MDX query running fine in Management studio, but it can not run in job agent, error massage:
[136] Job testcube reported: Microsoft.AnalysisServices.Xmla.XmlaException: CREATE GLOBAL CUBE statement. FILENAME|C:\dw\cube\monthly\mycube.cub|DDL|<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Create AllowOverwrite="true"><ObjectDefinition><Database><ID>mycube</ID>
<Name>mycube</Name>
<Cubes><Cube><ID>mycube</ID><Name>mycube</Name>
<ScriptErrorHandlingMode>IgnoreAll</ScriptErrorHandlingMode>
<MeasureGroups><MeasureGroup>
<ID>Fact mycube</ID><Name>Fact mycube</Name>
<Source xsi:type="MeasureGroupBinding"><DataSourceID>mycube</DataSourceID><CubeID>mycube</CubeID><MeasureGroupID>Fact mycube</MeasureGroupID><Persistence>All</Persistence></Source><IgnoreUnrelatedDimensions>true</IgnoreUnrelatedDimensions><Measures><Measure><ID>Count Orders</ID><Name>Count Orders</Name><Visible>true</Visible><AggregateFunction>Sum</Aggregat

Anyone could help with? any suggestions?

Thanks in advance.

Is this the entire error message? And can you post your MDX? How is your job set up that calls this?

Thanks,

~Shari

|||Thanks for the response.

Following are the job step set up.
We created a new job and new step.
step name:testcube
Type: SQL Server Analysis Services Query
Run as: SQL Agent Service Account
server: my_server_name
database: mycube
commond:
CREATE GLOBAL CUBE mycube
Storage 'C:\DW\cube\monthly\mycube.cub'
FROM [mycube]
(
MEASURE [mycube].[Count Orders],
DIMENSION [mycube].[All Languages],
DIMENSION [mycube].[All Order Methods],
DIMENSION [mycube].[All Periods],
DIMENSION [mycube].[All Products],
DIMENSION [mycube].[All Reasons]
)

The message is entire error message which I can see, but seems already truncated.

Am I missing something?

Thanks.
|||

The error might be caused by lack of permissions on the Analysis Services server with the SQL Agent Service account.

Try to temporarily make SQL Agent Service an administrator for Analysis Services (start SQL Management Studio, right click on the AS server, Properties, Security tab). If that fixes the error, then you'll need to create (or edit) a role that allows querying the cube and has the SQL Agent Service as member.

|||Thank you very much Adrian for the suggestion.

We add administrator to Analysis Services, but the error is still the same.

What else I can try?

Thanks.
|||The error must be hidden in the log file for your job (process). It appears that the real problem is hidden deeper in the error.|||

Try running the create global cube ... MDX from within the Management Studio, cube you are referring to. Let me know if the cube gets built without error.

Thanks,

Shari

|||Thanks Shari for the reply.

The MDX "create global cube" query works fine in Management Studio, and it is created cub file.
The log file contents in SQL Server Agent are same as log file viewer.

What else I can check and try?

Thanks a lot.

|||Hi SQLexperts,

We created a domain\sqladmin user on the sql server, granted all privileges to this user and added this user to Analysis Service user group, but we still get the same error. We stuck on this problem a while, anyone could give us some suggestions? or another way to work around?

Any one have successed run MDX on SQL Agent, I would be grateful for that information.
Appreciate the help.
|||

Another way that I create the global cubes is through a SSIS package. Are you familiar with creating packages? I run the global build each night to create "fresh" files for offline use.

I am wondering now though if it is a permission issue, maybe one of the services is runniing locally but needs Network access and should be run as a Network Service.

~Shari

|||We still not solve this issue yet.
I have tried SSIS, no luck.
Which control flow you use? Analysis Service Execute DDL task or Processing task?

Could you kindly give me direction?

Appreciate any help.

|||

OLAP_user ... email me directly

hopefully you copied my email address already

|||Hello Sharil,

Unfortunately I do not know where can copy your email.

Thanks.

|||

When you tested your create cube statement from SSMS, were you logged in as the domain\sqladmin account? I find that logging in as the service account is sometimes the easiest way to track down some of these issues when a taks works for me, but fails when it is scheduled.

Aslo, have you checked that this user has access to the 'C:\DW\cube\monthly' folders?

|||

We use the following steps in the package to create nightly refreshes of the global cubes"

1. Execute SQL task - this has MDX that creates a MDX statement for each sales rep.

2. For Each loop - loops through each sales rep's MDX to create a single global file per rep

It is a pretty simple package. And if you are just creating one static global cube then you wouldn't need the ForEach loop. You would just need Execute SQL Task. And some notification as far as success or failure.

Does this help?

~Shari

run MDX query in SQL Server Agent issue

Hello,

We have 'Create global cube' MDX query running fine in Management studio, but it can not run in job agent, error massage:
[136] Job testcube reported: Microsoft.AnalysisServices.Xmla.XmlaException: CREATE GLOBAL CUBE statement. FILENAME|C:\dw\cube\monthly\mycube.cub|DDL|<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Create AllowOverwrite="true"><ObjectDefinition><Database><ID>mycube</ID>
<Name>mycube</Name>
<Cubes><Cube><ID>mycube</ID><Name>mycube</Name>
<ScriptErrorHandlingMode>IgnoreAll</ScriptErrorHandlingMode>
<MeasureGroups><MeasureGroup>
<ID>Fact mycube</ID><Name>Fact mycube</Name>
<Source xsi:type="MeasureGroupBinding"><DataSourceID>mycube</DataSourceID><CubeID>mycube</CubeID><MeasureGroupID>Fact mycube</MeasureGroupID><Persistence>All</Persistence></Source><IgnoreUnrelatedDimensions>true</IgnoreUnrelatedDimensions><Measures><Measure><ID>Count Orders</ID><Name>Count Orders</Name><Visible>true</Visible><AggregateFunction>Sum</Aggregat

Anyone could help with? any suggestions?

Thanks in advance.

Is this the entire error message? And can you post your MDX? How is your job set up that calls this?

Thanks,

~Shari

|||Thanks for the response.

Following are the job step set up.
We created a new job and new step.
step name:testcube
Type: SQL Server Analysis Services Query
Run as: SQL Agent Service Account
server: my_server_name
database: mycube
commond:
CREATE GLOBAL CUBE mycube
Storage 'C:\DW\cube\monthly\mycube.cub'
FROM [mycube]
(
MEASURE [mycube].[Count Orders],
DIMENSION [mycube].[All Languages],
DIMENSION [mycube].[All Order Methods],
DIMENSION [mycube].[All Periods],
DIMENSION [mycube].[All Products],
DIMENSION [mycube].[All Reasons]
)

The message is entire error message which I can see, but seems already truncated.

Am I missing something?

Thanks.
|||

The error might be caused by lack of permissions on the Analysis Services server with the SQL Agent Service account.

Try to temporarily make SQL Agent Service an administrator for Analysis Services (start SQL Management Studio, right click on the AS server, Properties, Security tab). If that fixes the error, then you'll need to create (or edit) a role that allows querying the cube and has the SQL Agent Service as member.

|||Thank you very much Adrian for the suggestion.

We add administrator to Analysis Services, but the error is still the same.

What else I can try?

Thanks.
|||The error must be hidden in the log file for your job (process). It appears that the real problem is hidden deeper in the error.|||

Try running the create global cube ... MDX from within the Management Studio, cube you are referring to. Let me know if the cube gets built without error.

Thanks,

Shari

|||Thanks Shari for the reply.

The MDX "create global cube" query works fine in Management Studio, and it is created cub file.
The log file contents in SQL Server Agent are same as log file viewer.

What else I can check and try?

Thanks a lot.

|||Hi SQLexperts,

We created a domain\sqladmin user on the sql server, granted all privileges to this user and added this user to Analysis Service user group, but we still get the same error. We stuck on this problem a while, anyone could give us some suggestions? or another way to work around?

Any one have successed run MDX on SQL Agent, I would be grateful for that information.
Appreciate the help.
|||

Another way that I create the global cubes is through a SSIS package. Are you familiar with creating packages? I run the global build each night to create "fresh" files for offline use.

I am wondering now though if it is a permission issue, maybe one of the services is runniing locally but needs Network access and should be run as a Network Service.

~Shari

|||We still not solve this issue yet.
I have tried SSIS, no luck.
Which control flow you use? Analysis Service Execute DDL task or Processing task?

Could you kindly give me direction?

Appreciate any help.

|||

OLAP_user ... email me directly

hopefully you copied my email address already

|||Hello Sharil,

Unfortunately I do not know where can copy your email.

Thanks.

|||

When you tested your create cube statement from SSMS, were you logged in as the domain\sqladmin account? I find that logging in as the service account is sometimes the easiest way to track down some of these issues when a taks works for me, but fails when it is scheduled.

Aslo, have you checked that this user has access to the 'C:\DW\cube\monthly' folders?

|||

We use the following steps in the package to create nightly refreshes of the global cubes"

1. Execute SQL task - this has MDX that creates a MDX statement for each sales rep.

2. For Each loop - loops through each sales rep's MDX to create a single global file per rep

It is a pretty simple package. And if you are just creating one static global cube then you wouldn't need the ForEach loop. You would just need Execute SQL Task. And some notification as far as success or failure.

Does this help?

~Shari

run IIS error?

When i go to My computer-Manage-IIS(restart).
I have folowing error message;
The service has not been started.
I did reinstall IIS.
What should i do to run IIS?
Thanks.On Jul 5, 5:40 pm, GGill <G...@.discussions.microsoft.com> wrote:
> When i go to My computer-Manage-IIS(restart).
> I have folowing error message;
> The service has not been started.
> I did reinstall IIS.
> What should i do to run IIS?
> Thanks.
This article is a bit old; but, it might be of use.
http://groups.google.com/group/microsoft.public.inetserver.misc/browse_thread/thread/34d8669353f6e8d1/d7598968da3a7112?lnk=st&q=service+has+not+been+started+IIS&rnum=11#d7598968da3a7112
Regards,
Enrique Martinez
Sr. Software Consultant

Run dynamic SQL in debugger, get sql dump

Hi,
One of our developer runs a stored procedure containing dynamic SQL in
T-SQL Debugger. She consistently gets error ( see below ):
SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
If she runs it without debugger, it runs fine. She checks the code many
times and can't find anything wrong in the code. We have no idea what's
wrong.
The server is a SQL Server 2000 (SP3) on a Window 2000 with service pack
4.
Thank you.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Did you Google for an answer? I searched for below keywords:
c0000005 EXCEPTION_ACCESS_VIOLATION debug
And got some 100 matches. One plausible is http://support.microsoft.com/default...;EN-US;270061.
If you can't find a KB that applies to you, and you are current on service pack, you need to open a case with
MS, since access violations (etc) are most often bugs in SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yanjie Ren" <yren@.cc3.com> wrote in message news:%23lZEgg3iEHA.396@.TK2MSFTNGP12.phx.gbl...
>
> Hi,
> One of our developer runs a stored procedure containing dynamic SQL in
> T-SQL Debugger. She consistently gets error ( see below ):
> SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> If she runs it without debugger, it runs fine. She checks the code many
> times and can't find anything wrong in the code. We have no idea what's
> wrong.
> The server is a SQL Server 2000 (SP3) on a Window 2000 with service pack
> 4.
> Thank you.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Run dynamic SQL in debugger, get sql dump

If memory serves there was a bug with the debugger where
if you run it from the client machine it would either not
work, or result in an error (sorry can't find the
Microsoft Page).
How I solved this is to run the debugger on the server.
One of the Great Ones, Uri, Narayana, Wayne, Dejan, Tibor,
Dan, Andrew or Adam could probably tell you the reason and
the fix.
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan

>--Original Message--
>
>Hi,
>One of our developer runs a stored procedure containing
dynamic SQL in
>T-SQL Debugger. She consistently gets error ( see below ):
>SqlDumpExceptionHandler: Process 73 generated fatal
exception c0000005
>EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating
this process.
>If she runs it without debugger, it runs fine. She checks
the code many
>times and can't find anything wrong in the code. We have
no idea what's
>wrong.
>The server is a SQL Server 2000 (SP3) on a Window 2000
with service pack
>4.
>Thank you.
>
>*** Sent via Developersdex http://www.codecomments.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>
Thanx for the response.
She ran it on the server and got the same error.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Run dynamic SQL in debugger, get sql dump

If memory serves there was a bug with the debugger where
if you run it from the client machine it would either not
work, or result in an error (sorry can't find the
Microsoft Page).
How I solved this is to run the debugger on the server.
One of the Great Ones, Uri, Narayana, Wayne, Dejan, Tibor,
Dan, Andrew or Adam could probably tell you the reason and
the fix.
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan

>--Original Message--
>
>Hi,
>One of our developer runs a stored procedure containing
dynamic SQL in
>T-SQL Debugger. She consistently gets error ( see below ):
>SqlDumpExceptionHandler: Process 73 generated fatal
exception c0000005
>EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating
this process.
>If she runs it without debugger, it runs fine. She checks
the code many
>times and can't find anything wrong in the code. We have
no idea what's
>wrong.
>The server is a SQL Server 2000 (SP3) on a Window 2000
with service pack
>4.
>Thank you.
>
>*** Sent via Developersdex http://www.codecomments.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>Thanx for the response.
She ran it on the server and got the same error.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Run dynamic SQL in debugger, get sql dump

Hi,
One of our developer runs a stored procedure containing dynamic SQL in
T-SQL Debugger. She consistently gets error ( see below ):
SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
If she runs it without debugger, it runs fine. She checks the code many
times and can't find anything wrong in the code. We have no idea what's
wrong.
The server is a SQL Server 2000 (SP3) on a Window 2000 with service pack
4.
Thank you.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Did you Google for an answer? I searched for below keywords:
c0000005 EXCEPTION_ACCESS_VIOLATION debug
And got some 100 matches. One plausible is px?scid=kb;EN-US;270061." target="_blank">http://support.microsoft.com/defaul...b;EN-US;270061.
If you can't find a KB that applies to you, and you are current on service p
ack, you need to open a case with
MS, since access violations (etc) are most often bugs in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yanjie Ren" <yren@.cc3.com> wrote in message news:%23lZEgg3iEHA.396@.TK2MSFTNGP12.phx.gbl...[
vbcol=seagreen]
>
> Hi,
> One of our developer runs a stored procedure containing dynamic SQL in
> T-SQL Debugger. She consistently gets error ( see below ):
> SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> If she runs it without debugger, it runs fine. She checks the code many
> times and can't find anything wrong in the code. We have no idea what's
> wrong.
> The server is a SQL Server 2000 (SP3) on a Window 2000 with service pack
> 4.
> Thank you.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it![/vbcol]

Run dynamic SQL in debugger, get sql dump

Hi,
One of our developer runs a stored procedure containing dynamic SQL in
T-SQL Debugger. She consistently gets error ( see below ):
SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
If she runs it without debugger, it runs fine. She checks the code many
times and can't find anything wrong in the code. We have no idea what's
wrong.
The server is a SQL Server 2000 (SP3) on a Window 2000 with service pack
4.
Thank you.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!If memory serves there was a bug with the debugger where
if you run it from the client machine it would either not
work, or result in an error (sorry can't find the
Microsoft Page).
How I solved this is to run the debugger on the server.
One of the Great Ones, Uri, Narayana, Wayne, Dejan, Tibor,
Dan, Andrew or Adam could probably tell you the reason and
the fix.
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan
>--Original Message--
>
>Hi,
>One of our developer runs a stored procedure containing
dynamic SQL in
>T-SQL Debugger. She consistently gets error ( see below ):
>SqlDumpExceptionHandler: Process 73 generated fatal
exception c0000005
>EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating
this process.
>If she runs it without debugger, it runs fine. She checks
the code many
>times and can't find anything wrong in the code. We have
no idea what's
>wrong.
>The server is a SQL Server 2000 (SP3) on a Window 2000
with service pack
>4.
>Thank you.
>
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>|||and Jacco, certinly must not forget Jacco...
Peter
>--Original Message--
>If memory serves there was a bug with the debugger where
>if you run it from the client machine it would either not
>work, or result in an error (sorry can't find the
>Microsoft Page).
>How I solved this is to run the debugger on the server.
>One of the Great Ones, Uri, Narayana, Wayne, Dejan,
Tibor,
>Dan, Andrew or Adam could probably tell you the reason
and
>the fix.
>Peter
>"I favor the Civil Rights Act of 1964 and it must be
>enforced at gunpoint if necessary."
>Ronald Reagan
>
>
>
>>--Original Message--
>>
>>Hi,
>>One of our developer runs a stored procedure containing
>dynamic SQL in
>>T-SQL Debugger. She consistently gets error ( see
below ):
>>SqlDumpExceptionHandler: Process 73 generated fatal
>exception c0000005
>>EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating
>this process.
>>If she runs it without debugger, it runs fine. She
checks
>the code many
>>times and can't find anything wrong in the code. We have
>no idea what's
>>wrong.
>>The server is a SQL Server 2000 (SP3) on a Window 2000
>with service pack
>>4.
>>Thank you.
>>
>>*** Sent via Developersdex http://www.developersdex.com
>***
>>Don't just participate in USENET...get rewarded for it!
>>.
>.
>|||Did you Google for an answer? I searched for below keywords:
c0000005 EXCEPTION_ACCESS_VIOLATION debug
And got some 100 matches. One plausible is http://support.microsoft.com/default.aspx?scid=kb;EN-US;270061.
If you can't find a KB that applies to you, and you are current on service pack, you need to open a case with
MS, since access violations (etc) are most often bugs in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yanjie Ren" <yren@.cc3.com> wrote in message news:%23lZEgg3iEHA.396@.TK2MSFTNGP12.phx.gbl...
>
> Hi,
> One of our developer runs a stored procedure containing dynamic SQL in
> T-SQL Debugger. She consistently gets error ( see below ):
> SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> If she runs it without debugger, it runs fine. She checks the code many
> times and can't find anything wrong in the code. We have no idea what's
> wrong.
> The server is a SQL Server 2000 (SP3) on a Window 2000 with service pack
> 4.
> Thank you.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

RTM Integration Services Job

When I try to create a job step of type SQL Server Integration Services Package I get an error:

===================================

The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI)

Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.Microsoft.SqlServer.Management.SqlManagerUI.IJobStepPropertiesControl.Load(JobStepData data)
at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.typeList_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

And here's the version info:
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

As far as I can tell the Integration Services service is running and I installed all features for testing.

Any help is appreciated.

Larry

This might be due to an unclean uninstall of BETA 2005. I followed the directions for removing previous versions, but Reporting Services also wasn't working and the entire directory was missing. I did install to the D:\ but otherwise it was a fairly plain install.|||Ok, I uninstalled everything, deleted the orphaned directories and remaining 90 registry keys and reinstalled.

Reporting Services was really funky. It didn't work, the configuration assistant wouldn't let me change anything. I whacked the virtual directories created at install from IIS and had to delete the databases created during install. Stopped the service and then could get through configuration down to Initialization at which point I had to start the service to proceed. It seems to be working finally.

For the original problem:
When I try to create a job step of type SQL Server Integration Services Package I get an error:

It is still happening. Any help would be appreciated.|||Interestingly, I created a database diagram, and a maintenance plan and suddenly the interface for Integration Services jobs started working. No idea why, but I'm not fond of magic interfaces, and yet mildly pleased that it's working.

RSWebParts.cab install and Command Line Error

Hi all,
I have SQL Server 2005 installed on one server and WSS 3.0 installed
on another server. I would like to install the reporting services wbe
parts (RSWebParts.cab) to my WSS Server. I have copied the file across
and am using the following command:
:: ***********PARAMS***********
:: stsadm tool
SET STSADMTOOL="C:\Program Files\Common Files\Microsoft Shared\web
server extensions\12\bin\stsadm.exe"
GOTO STOP
:STOP
%STSADMTOOL% -help addwppack
pause;
echo using STSADMTOOL at %STSADMTOOL%
%STSADMTOOL% -o addwppack -force -filename C:\ReportingServices
\RSWebParts.cab
When I run it I get a Command Line Error and it points me in the
direction of stsadm help. I can guarantee you the files are in the
correct location as per the parameters passed in and that I am a local
admin on the server.
This is driving me nuts, can anybody help asap?
Cheers
JimskiI have the same problem.  I am losing faith in Microsoft.  Have you ever found a solution?

rsUnexpectedError

On one of my reports, I am getting the following error when I try to print:
An unexpected error occurred in Report Processing. (rsUnexpectedError)
I have read from somewhere that it is because I have a subreport within a
table on my report. Does anyone know if that is true and if so, what is the
fix for it?Hi,
Welcome to use MSDN Managed Newsgroup!
I have also noticed that many of such error was caused by SubReport. Is it
possible for you to reproduce this via AdventureWorks and send me the rdl
file for me to reproduce it on my side? Since this is such a common error
message, we should look into this further.
Also, I understand the information may be sensitive to you, my direct email
address is v-mingqc@.online.microsoft.com (please make sure you have removed
"online" before you click SEND), you may send the file to me directly and I
will keep secure.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.