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