วันพุธที่ 13 มิถุนายน พ.ศ. 2555

Process INDEX Error , Code 3238133761


<return xmlns="urn:schemas-microsoft-com:xml-analysis">
  <results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty">
      <Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" />
      <Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
        <Error ErrorCode="3238133761" Description="File system error: The following error occurred while opening the file '\\?\F:\TSC Projects\OLAP\Data\olap_tsc401.76.db\Cube_TXNs.108.cub\Txns Terminal.0.det\Fact TXNs Y200812.0.prt\6.string.data'." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
        <Error ErrorCode="3238133761" Description="File system error: The following error occurred while opening the file '\\?\F:\TSC Projects\OLAP\Data\olap_tsc401.76.db\Cube_TXNs.108.cub\Txns Terminal.0.det\Fact TXNs Y200812.0.prt\6.string.data'." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
        <Error ErrorCode="3240034325" Description="Errors in the OLAP storage engine: An error occurred while processing the indexes for the Fact TXNs Y200812 partition of the TID measure group of the Cube_TXNs cube from the olap_tsc401 database." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
        <Error ErrorCode="3239837698" Description="Server: The operation has been cancelled." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
      Messages>
    root>
  results>
return>


ยังหาสาเหตุไม่ได้ แต่คาดว่าน่าจะเกิดจาก Memory ไม่พอขณะทำการ Restore OLAP Database


วันพฤหัสบดีที่ 24 พฤษภาคม พ.ศ. 2555

Using DMV in SQL 2008 for finding informations

http://www.sqlsoldier.com/wp/sqlserver/usingsystemrestrictschemafunctioninmdxtoquerydmvs


Key words = DMV , SQL 2008

Combine CSV files via dos command

Open command prompt.

Type copy c:\*.csv c:\combine.csv and press enter

This will combine all of the csv files that are in your root c:\ directory into one file called File.csv.

You can change the file names and paths as necessary.

วันพุธที่ 23 พฤษภาคม พ.ศ. 2555

SSIS Designer does not remember visible area

Ref to : http://stackoverflow.com/questions/6095186/ssis-designer-does-not-remember-visible-area

Content

 get around this problem by doing the following:
  1. Set zoom to 100% (View -> Zoom -> 100%) Note: you may have to click in the designer pane to get Zoom to show on the view menu.
  2. Scroll the window to where you want it be when you open up the package.
  3. Select and move a task.
  4. Save file
For step 3, I usually select the top task and press Ctrl-[left arrow], Ctrl-[right arrow]. I like tasks to stay where I put them! :)
Hope that helps.

WORK ครับ

Reporting service ,Operation is not valid due to the current state of the object

Reporting service ,Operation is not valid due to the current state of the object
Resolve :  http://www.sqlservercentral.com/Forums/Topic692785-147-1.aspx#bm1240909


By Sandy Westman

Error ใน Reporting service : กรณี Long run parameter ทำให้เกิด  Error
ให้เปิด config file แล้ว Add key

 C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager.