Error when trying to process cube after SP2

Hi Guys

Seems a nasty error started to appear after I installed SP2 on the corporate server and my machine and then trying to process a cube. Process goes through fine, but when I try to browse it a following error pops up. If anyone can help me with this, that would be great.

Parser: The end of the input was reached. (Microsoft SQL Server 2005 Analysis Services)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, AdomdRestrictionCollection restrictions)
at Microsoft.AnalysisServices.Browse.CubeBrowser.BrowsableObjectsManager.Refresh()
at Microsoft.AnalysisServices.Browse.CubeBrowser.BrowsableObjectsManager.UpdateComboBox()
at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate)
at Microsoft.AnalysisServices.Browse.CubeBrowser.ReconnectCanFail()
at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)

Thank you

Found a problem: the default measures were not set up in perspectives. Hmm... I thought the first one will be selected automatically.

Error when trying to edit a DTS package - please help

SQL2000 sp2 and sp3a
I'm having trouble getting into DTS design view on a
particular pc. I can get in fine on other pcs. This
apparently started happening just after installing sp3a on
my local machine. The pc I am using can't be rebuilt and
I can't use a different pc. I get a couple of error
messages. After clicking design package, I ge the
following error "Error occurred during creation of a DTS
Package". After clicking ok, I get "The selected package
cannot be opened. The DTS Designer has been closed".
This happens on all packages on all servers (and local)
for the pc I am using. I found one bit of information on
the net, but it didn't help. It was at:
http://www.sqldts.com/default.aspx?228 I then uninstalled
sql and reinstalled. That still didn't work. I've
uninstalled and put sp2, sp3a, different combinations a
few times and still no luck. Has anyone experienced this
or does anyone have any suggestions?
Thanks,
Van JonesThis can happen if the MDAC installation gets corrupted. Since you have
installed SQL Server SP3 then you have MDAC 2.7 SP1. The only way to
correct the MDAC installation would be to install MDAC 2.8 on this server.
Unless this is will cause a problem for you, you can possibly fix the
problem by installing MDAC 2.8.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Error when sending scheduled report

We are using SQL Server 2005 SP2. We have setup the RS smtp configuration
and we we have created scheduled reports, but we get an error when the
report is emailed. If I understand correctly, the account name/password
that is used for authentication is the account name used for the SQL Server
Reporting Services service. I have edit the rsreportserver.config file and
changed the SMTPAuthenticate to 2. The SMTP server is configured to point
to an external SMTP server.
The error we receive is: Failure sending mail: The message could not be sent
to the SMTP server. The transport error code was 0x80040217. The server
response was not available.Make sure that you don't have an antivirus/firewall blocking port 25 because
it sounds like your report server is not able to innitiate a connection to
the mail server. You can also try telnetting your smtp server from your
report server on port 25 by typing "telnet smtpservername 25" at the comand
prompt on the report server. If that commnad times out then you have a
netwroking problem whether it be a physical problem, a routing problem or a
firewall problem.
"Tim Kelley" <tkelley@.company.com> wrote in message
news:uESIb0ljHHA.4936@.TK2MSFTNGP03.phx.gbl...
> We are using SQL Server 2005 SP2. We have setup the RS smtp configuration
> and we we have created scheduled reports, but we get an error when the
> report is emailed. If I understand correctly, the account name/password
> that is used for authentication is the account name used for the SQL
> Server Reporting Services service. I have edit the rsreportserver.config
> file and changed the SMTPAuthenticate to 2. The SMTP server is configured
> to point to an external SMTP server.
> The error we receive is: Failure sending mail: The message could not be
> sent to the SMTP server. The transport error code was 0x80040217. The
> server response was not available.
>|||I was able to connect to the smtp server from our RS server. Any other
ideas?
Could it be an authentication issue?
Thanks,
Tim
"TJ Davis" <TJDavis@.sagu.edu> wrote in message
news:eumMVKmjHHA.4248@.TK2MSFTNGP06.phx.gbl...
> Make sure that you don't have an antivirus/firewall blocking port 25
> because it sounds like your report server is not able to innitiate a
> connection to the mail server. You can also try telnetting your smtp
> server from your report server on port 25 by typing "telnet smtpservername
> 25" at the comand prompt on the report server. If that commnad times out
> then you have a netwroking problem whether it be a physical problem, a
> routing problem or a firewall problem.
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:uESIb0ljHHA.4936@.TK2MSFTNGP03.phx.gbl...
>> We are using SQL Server 2005 SP2. We have setup the RS smtp
>> configuration and we we have created scheduled reports, but we get an
>> error when the report is emailed. If I understand correctly, the account
>> name/password that is used for authentication is the account name used
>> for the SQL Server Reporting Services service. I have edit the
>> rsreportserver.config file and changed the SMTPAuthenticate to 2. The
>> SMTP server is configured to point to an external SMTP server.
>> The error we receive is: Failure sending mail: The message could not be
>> sent to the SMTP server. The transport error code was 0x80040217. The
>> server response was not available.
>

ERROR WHEN I TRY TO EDIT A SCRIPT TASK

Today, I must to re-install VS2005 and SQL Server 2005 desktop tools in my computer, because I install SQL Server 2005 SP2 desktop tool for an special features that I need.

This caused that the edition of the Script Task gives to me the following error:

Cannot show the editor for this task

Additional information:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa.DT)

After the reinstalación, the error continues appearing, and I do not know that to do so that it works fine again.

Can any help me with this?

Thanks.

Alejandro

Are you on Vista?

http://blogs.msdn.com/mattm/archive/2007/03/09/sp2-vista-and-script-tasks.aspx|||No. I′m in XP SP2|||

Take a look at this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1270413&SiteID=1

sql

Error When Creating Maintenance Plan after SP2

Exception has been thrown by the target of an invocation (mscorlib)
Additional information:
Creating instance of the COM component with CLSID
{E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
to the following
error: c001f011. (Microsoft.SQLServer.ManagedDTS)
IClassFactory
Microsoft.SQLServer.ManagedDTS
... any ideas?You could try the 3152 cumulative hotfix, which corrected a few issues with
maintenance plans that SP2 either introduced or didn't address.
http://support.microsoft.com/kb/933097/
There is also another GDR / QFE coming soon. See:
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<michad76@.gmail.com> wrote in message
news:1174571688.759138.320150@.o5g2000hsb.googlegroups.com...
> Exception has been thrown by the target of an invocation (mscorlib)
> Additional information:
> Creating instance of the COM component with CLSID
> {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
> to the following
> error: c001f011. (Microsoft.SQLServer.ManagedDTS)
>
> IClassFactory
> Microsoft.SQLServer.ManagedDTS
> ... any ideas?
>

Error When Creating Maintenance Plan after SP2

Exception has been thrown by the target of an invocation (mscorlib)
Additional information:
Creating instance of the COM component with CLSID
{E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
to the following
error: c001f011. (Microsoft.SQLServer.ManagedDTS)
IClassFactory
Microsoft.SQLServer.ManagedDTS
... any ideas?You could try the 3152 cumulative hotfix, which corrected a few issues with
maintenance plans that SP2 either introduced or didn't address.
http://support.microsoft.com/kb/933097/
There is also another GDR / QFE coming soon. See:
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<michad76@.gmail.com> wrote in message
news:1174571688.759138.320150@.o5g2000hsb.googlegroups.com...
> Exception has been thrown by the target of an invocation (mscorlib)
> Additional information:
> Creating instance of the COM component with CLSID
> {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
> to the following
> error: c001f011. (Microsoft.SQLServer.ManagedDTS)
>
> IClassFactory
> Microsoft.SQLServer.ManagedDTS
> ... any ideas?
>

Error to open SQL Profiler

I only Microsoft Clients Tools are installed in this Computer. Try to open
Profiler and Query Analyzer in Windows XP PRO SP2.
I get the following message:
"Program Files\Microsoft Sql Server\80\Tools\Binn\Profiler.exe is not a
valid Win32 application."
"Program Files\Microsoft Sql Server\80\Tools\Binn\isqlw.exe is not a valid
Win32 application."
How do I troubleshoot resolve this issue?
Thanks
Carlos Andrés Lozano G.
Solution Development
Try to reinstall Sql Server Client Tools.
Cristian Lefter, SQL Server MVP
"c@.rlos" <crlos@.discussions.microsoft.com> wrote in message
news:6266E3EB-6128-4E92-B640-E758ED1FB770@.microsoft.com...
>I only Microsoft Clients Tools are installed in this Computer. Try to open
> Profiler and Query Analyzer in Windows XP PRO SP2.
> I get the following message:
> "Program Files\Microsoft Sql Server\80\Tools\Binn\Profiler.exe is not a
> valid Win32 application."
> "Program Files\Microsoft Sql Server\80\Tools\Binn\isqlw.exe is not a valid
> Win32 application."
> How do I troubleshoot resolve this issue?
> --
> Thanks
> Carlos Andrs Lozano G.
> Solution Development
|||I have installed in 3 occasions and the same error leaves.
Will be able to be the computer?
"Cristian Lefter" wrote:

> Try to reinstall Sql Server Client Tools.
> Cristian Lefter, SQL Server MVP
|||c@.rlos wrote:[vbcol=seagreen]
> I have installed in 3 occasions and the same error leaves.
> Will be able to be the computer?
> "Cristian Lefter" wrote:
Try uninstalling the client tools, reinstalling from the SQL Server CD,
and then applying either the SP3a or SP4 (if you're already using SP4)
to the client. Make sure you install using an admin account.
Barring that option, you may have some unrelated corruption on the PC.
You could try reinstalling MDAC from http://www.microsoft.com/data.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||The installers are found in a unit shared of the Servant. We have done the
installation in a Windows 2000 and functions without problems
"David Gugick" escribió:

> Try uninstalling the client tools, reinstalling from the SQL Server CD,
> and then applying either the SP3a or SP4 (if you're already using SP4)
> to the client. Make sure you install using an admin account.
> Barring that option, you may have some unrelated corruption on the PC.
> You could try reinstalling MDAC from http://www.microsoft.com/data.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||isqlw is not a valid Win32 application
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Are you sure?
"Durga Prasad Datta" wrote:

> isqlw is not a valid Win32 application
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Durga Prasad Datta wrote:
> isqlw is not a valid Win32 application
>
It's a valid Windows EXE as far as I know. If you open up the EXE you
can see the ubiquitous "The program cannot be run in DOS mode" message
in the EXE header.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Error setting up Distribution on SQL 2005 SP2

I am attempting to set up Distribution on SQL 2005 using the wizard.

All goes well until the actual script fires off... this line:

use master

exec sp_adddistributor @.distributor = N'NAVSOLDEV\SQLSERVER2005', @.password = N''

GO

Causes this error:

Msg 22538, Level 16, State 1, Procedure sp_MSrepl_check_job_access, Line 155

Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.

The rest of the script fails due to this line... Now, I am fair at SQL, but I am no DBA. I did some searching and found one post that seemed to have the same problem, and the gentleman solved it himself, but did not explain how lol.

Any help greatly appreciated!

Dave Borneman

What user account are you using?

Only members of the sysadmin fixed server role can execute sp_adddistributor.

Gary

|||

I am using Windows Authentication... but knowing that I will play around. Will post here if that fixes the problem.

Dave

|||

I logged in with sa, which is a member of sysadmin.

You mentioned the "fixed" server role... Is the "fix" something I have to apply manually, or would it have been done with SP1 or SP2?

Thanks!

Dave

|||

Login as 'sa' should work. You shouldn't have to do anything extra.

Gary

|||

well, then it would appear that it might not be a permissions issue.

Anyone have any other ideas?

Dave

|||

To further troubleshooting, you can open SQL profiler. Choose template TSQL_SPs to enable line by line profiling and try to call sp_adddistributor again. You should be able to see where the error message is thrown by searching error code 22538.

Peng

|||

I dont know how much of this trace you need to see... its kinda ugly when copied in to a text window.

<code>

SP:StmtStarting IF EXISTS (SELECT * FROM msdb.dbo.sysjobs_view WHERE name = @.job_name collate database_default and
UPPER(originating_server collate database_default) = UPPER(CONVERT(sysname, SERVERPROPERTY('ServerName')))
and master_server = 0)
1 master 528826079 sp_MScreate_replication_checkup_agent NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.523
SP:StmtStarting EXEC @.retcode = sys.sp_MSdrop_repl_job @.job_name = @.job_name
1 master 528826079 sp_MScreate_replication_checkup_agent NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.523
SP:Starting EXEC @.retcode = sys.sp_MSdrop_repl_job @.job_name = @.job_name
1 master 919003015 sp_MSdrop_repl_job NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.553
SP:StmtStarting SELECT @.job_found = 0

1 master 919003015 sp_MSdrop_repl_job NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.553
SP:StmtStarting EXEC @.retcode = sys.sp_MSrepl_check_job_access @.id = @.job_id,
@.step_uid = @.job_step_uid,
@.name = @.job_name,
@.err_not_found = 0,
@.job_found = @.job_found output
1 master 919003015 sp_MSdrop_repl_job NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.553
SP:Starting EXEC @.retcode = sys.sp_MSrepl_check_job_access @.id = @.job_id,
@.step_uid = @.job_step_uid,
@.name = @.job_name,
@.err_not_found = 0,
@.job_found = @.job_found output
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.category_id = NULL,
@.subsystem = NULL,
@.database = NULL,
@.job_found = 0

-- Retrieve the JOB Category and Owner ID
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.owner_sid = owner_sid,
@.category_id = category_id
FROM msdb.dbo.sysjobs
WHERE job_id = @.id
OR name = @.name

-- Verify that the job was found
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.@.ROWCOUNT < 1
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.job_found = 1

-- Retrieve the JOB Subsystem and Database
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting SELECT @.subsystem = sjs.subsystem,
@.database = sjs.database_name
FROM msdb.dbo.sysjobs as sj
JOIN msdb.dbo.sysjobsteps as sjs
ON sj.job_id = sjs.job_id
WHERE (sj.job_id = @.id
OR sj.name = @.name)
AND sjs.step_uid = ISNULL(@.step_uid, sjs.step_uid)
AND sjs.step_id = ISNULL(@.step_id, sjs.step_id)
AND ((sj.category_id = 10
AND sjs.subsystem = N'Distribution')
OR (sj.category_id = 14
AND sjs.subsystem = N'Merge')
OR (sj.category_id = 13
AND sjs.subsystem = N'LogReader')
OR (sj.category_id = 15
AND sjs.subsystem = N'Snapshot')
OR (sj.category_id = 19
AND sjs.subsystem = N'QueueReader')
OR (@.category_id IN (18, 16, 11, 12, 20, 17)
AND sjs.subsystem = N'TSQL'))

-- if current user is the owner of the job then all we can
-- skip straight to ensuring this is a replication job... if
-- not then we need to do some more verification before hand
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.owner_sid != SUSER_SID()
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.category_id IN (10, 13, 14, 15, 19)
AND NOT (@.database = DB_NAME()
AND IS_MEMBER('db_owner') = 1)
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF @.category_id IN (18, 16, 11, 12, 20, 17)
AND IS_SRVROLEMEMBER('sysadmin') != 1
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting IF NOT (@.category_id = 10
AND @.subsystem = N'Distribution')
AND NOT (@.category_id = 14
AND @.subsystem = N'Merge')
AND NOT (@.category_id = 13
AND @.subsystem = N'LogReader')
AND NOT (@.category_id = 15
AND @.subsystem = N'Snapshot')
AND NOT (@.category_id = 19
AND @.subsystem = N'QueueReader')
-- 18 = REPL-Alert Response
-- 16 = REPL-Checkup
-- 11 = REPL-Distribution Cleanup
-- 12 = REPL-History Cleanup
-- 20 = Replication
-- 17 = REPL-Subscription Cleanup
AND NOT (@.category_id IN (18, 16, 11, 12, 20, 17)
AND @.subsystem = N'TSQL')
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570
SP:StmtStarting RAISERROR(22538, 16, -1)
1 master 326665389 sp_MSrepl_check_job_access NAVSOLDEV\SQLSERVER2005 54 2007-03-06 19:20:11.570

</code>

I stopped at the raiserror - I assume anything after that is useless. Let me know if you need more above it... none of it seems to me to be anything obvious for causing that error.

Dave

|||

The profiler output is enough.

Just from the profiler output, sounds like you have lingering job left on your machine, either from previous replication or something else. Could you check if you have a job with name like "Replication agents checkup"? If you find this job, also check the entry for this job at msdb.dbo.sysjobs and msdb.dbo.sysjobsteps.

Peng

|||

Yes, that job exists, and has entries in those tables.

I disabled the job and re-ran the wizard, to the same effect.

Will deleting the rows in those tables that related to that job fix this? I hesitate to delete stuff from the master tables lol. This instance has never had replication enabled... so it shouldnt be "left over" from something... unless the install put it in there for some reason?

Dave

|||

Ok, great news.

Deleting or disabling the job is not enough. I had to also manually delete the entries in sysjobs, sysjobsteps and sysjobschedules in the msdb table. This fixed the install issue 100%.

Thanks all that helped with this!!

|||

Hey frostfire,

I am running into the same problem here with SQL2005, SP1. I see you have solved the problem by deleting the entries of the replication job. The same job does exist on my server and I'd like to give it a try, but am wondering that if you need to recover the job since it is setup by the initial installation.

Thanks for any advise !

nbtecha