June 21, 2010 at 1:57 am
Hey!
I have problems with my Sql job. When i am trying to process my ssas project (there is 3 cubes) with sql job, i am getting the following message:
Message
Executed as user: XXXX\User. Microsoft.AnalysisServices.Xmla.ConnectionException: A connection cannot be made.
Ensure that the server is running. ---> System.Net.Sockets.SocketException: No such host is known at
System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at Microsoft.AnalysisServices.Xmla.XmlaClient.GetTcpClient
(ConnectionInfo connectionInfo) --- End of inner exception stack trace --- at
Microsoft.AnalysisServices.Xmla.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) at
Microsoft.AnalysisServices.Xmla.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) at
Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at
Microsoft.SqlServer.Management.Smo.Olap.SoapClient.Connect() at OlapEvent(SCH_STEP* pStep, SUBSYSTEM*
pSubSystem, SUBSYSTEMPARAMS* pSubSystemParams, Boolean fQueryFlag). The step failed.
If i run my ssas project manually on analysis server, everything goes without problems. My jobs Command (script) looks as follows:
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ErrorConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">
<KeyErrorLimitAction>StopLogging</KeyErrorLimitAction>
<KeyNotFound>IgnoreError</KeyNotFound>
</ErrorConfiguration>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">
<Object>
<DatabaseID>XXX</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Batch>
I have tried to change Service acoounts (with Sql server configuration manager), without any effect. I have also admin rights to the analysis server.
Any help will be appreciate!
June 21, 2010 at 2:30 am
Looks like a network problem. Is the SQLAgent machine the same as SSAS?
-- Gianluca Sartori
June 21, 2010 at 2:58 am
Yes, the machine is same with SqlAgent and SSAS.
June 21, 2010 at 3:02 am
This piece of the stack trace is self-explaining:
System.Net.Sockets.SocketException: No such host is known at
System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
It says host unknown.
-- Gianluca Sartori
June 21, 2010 at 7:11 am
Problem solved! There was an human mistake. Thanks for reply!
June 21, 2010 at 7:20 am
You're welcome. You could possibly post here what the issue was about, so that others can benefit from your experience.
-- Gianluca Sartori
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply