Problem Adding DW.pup Resource in Commerce Server 2009 R2 with SQL Server 2008 R2


hi,

i trying add dw.pup resource in commerce server 2009 unable to.

the error in log is:


[23:16:38] file decompression complete
[23:16:38] creating global resource global data warehouse
3/27/2011 11:16:52 pm  puplogfilename: c:\pup.log
3/27/2011 11:16:52 pm  isdbexisting: server: jarjarbinks, dbname: solutionstorefrontsite_datawarehouse
3/27/2011 11:16:52 pm  connecting server: jarjarbinks

time=sunday, march 27, 2011 23:16:52 site=solutionstorefrontsite  resource=global data warehouse   function=(null)
data warehouse schema exist in specified database. schema not recreated.
time=sunday, march 27, 2011 23:16:52 site=solutionstorefrontsite  resource=global data warehouse   function=colapstore::createschema
log olap database & cube creation found @ c:\commerceolap.log

time=sunday, march 27, 2011 23:16:52 site=solutionstorefrontsite  resource=global data warehouse   function=colapstore::createschema
c:\program files (x86)\microsoft commerce server 9.0\data\commerceolap.xmla3/27/2011 11:16:52 pm  initialize: server: jarjarbinks, cubefilename: c:\program files (x86)\microsoft commerce server 9.0\data\commerceolap.xmla, puplogfilename: c:\pup.log
3/27/2011 11:16:52 pm  connecting server: jarjarbinks

time=sunday, march 27, 2011 23:16:52 site=solutionstorefrontsite  resource=global data warehouse   function=hrdispcall
failed execute method createcubes
not load file or assembly 'microsoft.analysisservices, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91' or 1 of dependencies. system cannot find file specified.
time=sunday, march 27, 2011 23:16:52 site=solutionstorefrontsite  resource=global data warehouse   function=(null)
failed call method createcubes on microsoft.commerceserver.internal.analysis.puphelper.cubeinstaller.
time=sunday, march 27, 2011 23:16:52 site=solutionstorefrontsite  resource=global data warehouse   function=(null)
failed create olapstore schema.[23:16:52] error: not create global resource. error may occur because global resource same name exists. see trace information (above) more details.
[23:16:52] adding config data site data warehouse
[23:16:52] extracting config stream contents , putting in c:\users\administrator\appdata\local\temp\1\site data warehouse_config.blb file
[23:16:52] extracting object data site data warehouse config
[23:16:52] getting object data site data warehouse stream data
[23:16:52] extracting data stream contents , putting in c:\users\administrator\appdata\local\temp\1\site data warehouse.blb file
[23:16:53] operation completed
[23:16:54] displaying final information screen

can me please?

 

thanks.

best regards,

 

 

have created dw? since error tells "schema exists".

 

you can open commerce manager , delete dw resources. can open sql server management studio , delete created dw databases.

 

then can try add dw resource again using pup file

 

regards,
alen malhasoglu
http://alen.malhasoglu.com
http://ziver.blogspot.com
@alenmalhasoglu


Commerce Server  >  Commerce Server 2009



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

job syspolicy_purge_history job fail in sqlserver 2008

Image
hello guys, when installed sqlserver,it automatically created 1 job name job syspolicy_purge_history. but failed @ step 1. the reason is: date                11/6/2010 2:00:00 am log                job history (syspolicy_purge_history) step id                1 server                mxosv-otsdb01 job name                syspolicy_purge_history step name                verify automation enabled. duration                00:00:00 sql severity                16 sql message id                34022 operator emailed                operator net sent                operator paged                retries attempted                0 message executed user: nt authority\system. policy automation turned off. [sqlstate 42000] (error 34022).  the step failed. have run statement: select msdb.dbo.fn_syspolicy_is_automation_enabled the returned valus 0. what can resolve it? or can delete job manually.   thanks in advance. if haven't things want,be
Read more

Trying to register with public marketplace error with 'Get-AzureStackStampInformation'

when trying register against public azure adfs azure stack error below. logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  and  \\azs-ercs01\c$\maslogs error occurred checking stamp information: system.management.automation.remoteexception: term 'get-azurestackstampinformation' not recognized name of cmdlet, function, script file, or operable program. check spelling of name, or if path included, verify path correct , try again. @ c:\azurestack-tools-master\registration\registerwithazure.psm1:1106 char:5 +     throw "logs can found at: $global:azureregistrationlog  and  \ ... +     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : operationstopped: (logs can fou... , try again.:string) [], runtimeexception     + fullyqualifiederrorid : logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  a    nd  \\azs-ercs01\c$\maslogs error occurred chec
Read more