Viadeo

mardi 14 juin 2011

Xavave's new blog

my new blog (on wordpress) is here !

it replaces this one from now!

http://www.averbouch.biz

jeudi 28 avril 2011

Microsoft Community Contributor Award 2011

I’m very pleased and honored to share this with all of you that my community contributions have been recognized by Microsoft. I have received the Microsoft Community Contributor Award for year 2011.

mercredi 27 avril 2011

SQL2008 R2 Master Data Services Cumulative updates history and details

Hi,
here is a history of MDS cumulative updates / fixes

note : the latest cumulative update always contains all previous updates.
note 2:
here is another link for all SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released : http://support.microsoft.com/kb/981356/en-us
CU7 : http://support.microsoft.com/kb/2507770 (10.50.1777.0)
2516439 FIX: "The script '/MDM/ScriptResource.axd' contains multiple calls to Sys.Application.notifyScriptLoaded(). Only one is allowed" error on a SQL Server 2008 R2 MDS website

CU6 : http://support.microsoft.com/kb/2489376 (10.50.1765.0)

2486113 : A drop-down list is always displayed instead of a search box when you double-click the value of the filter criteria box for an attribute in Entities Explorer of the SQL Server 2008 R2 MDS website

2497301 FIX: "Validate Version" page takes a long time to open or times out after you click "Validate version" on the SQL Server 2008 R2 MDS website

CU5http://support.microsoft.com/kb/2438347
no MDS update in it (as far I know)

CU 4 : http://support.microsoft.com/kb/2345451 (10.50.1746.0)

2284503
FIX: You encounter two issues when you use Microsoft SQL Server 2008 R2 Master Data Services (MDS)

2410425
FIX: You receive an exception when you try to create an MDS database in SQL Server 2008 R2 MDS if a non-MDS database table is named "tblSystem"

2412136
FIX: The Entities Explorer grid displays few rows in a SQL Server 2008 R2 MDS website if you use a low screen resolution

CU3 : http://support.microsoft.com/kb/2261464
no MDS update in it (as far I know)

CU2 : http://support.microsoft.com/kb/2072493 (10.50.1720.0)

2143880
Bugs that are fixed in Microsoft SQL Server 2008 R2 Master Data Services June Update

CU1 http://support.microsoft.com/kb/981355
no MDS update in it (as far I know)

jeudi 31 mars 2011

Ria Ritchie - Where did it all go wrong Tab : chords and lyrics

Ria Ritchie - Where did it all go wrong (Acoustic)


this complete tab by XavAve
LYRICS and CHORDS !
F# Bbm7
I‘ve been thinkin, thinking bout how we fell apart
Ebm7 Db7M
I‘ve been hoping, hopin one day that your heart
F# Bbm7 Ebm7
will start dreaming, dreaming of me
G#m7
but that sunshine ive been waiting for
Db
seems to be gone

F# Bbm7
I‘ve been sinkin, i've been sinking since you left
Ebm7 Db7M
and i've been tryin tryin so hard to forget
F# Bbm7 Ebm7
but im still dreaming, dreaming of you
G#m7
and it's all because coz you left me
Db
yeah you left me alone

Bmaj7
and is it so wrong
Bm
to wish that we'd get along
Ebmin7
you told me you'd hold me
Ebm7 (then Db bass)
then sold it all
Bmaj7
and its been so long
Bm F#
so tell me where did it all go wrong?

F# Bbm7
I’ve been thinking, thinking bout how we used to talk
Ebm7 Db7M
and I’ve been missing, missing all your little faults
F# Bbm7 Ebm7
so I’m still dreaming, dreaming of you
G#m7
but that sunshine I’m waiting on
Db
seems to be gone

F# Bbm7
so I’ve been lyin, i've been lying to myself
Ebm7 Db7M
coz I’ve been holdin, holdin
F# Bbm7 Ebm7
onto something that is broken, broken in two
G#m7
and it's all because coz you left me
Db
yeah you left me alone


Bmaj7
Is it so wrong
Bm
to wish that we'd get along
Ebmin7
you told me you'd hold me
Ebm7 (then Db bass)
then sold it all
Bmaj7
and i was so strong
Bm
back then when we'd get along
Ebmin7
you'd tell me that you love me
Ebm7 (then Db bass)
but sold me onnnnnn ohhh
G#m7 Bbm7
so tell where did it all go wrong?

G#m7
ohhh ohhhh ohhhhh
G#m7 Am7 A#m7
G#m7
ohhh ohhhh ohhhhh
F# F#
Bmaj7
and is it so wrong
Bm
to wish that we'd get along
Ebmin7
you told me you'd hold me
Ebm7
then sold it all
Bmaj7
and i was so strong
Bm
back then when we'd get along
Ebmin7
you'd tell me that you love me
Ebm7 (then Db bass)
but sold me onnnnnn ohhh
G#m7 F#
so tell where did it all go wrong?

mercredi 16 mars 2011

music break!

Master Data Services : Getting Errors out of a ModelMembersBulkUpdate/Merge with API


In fact, you can get the error codes on MDS website : in "Integration Management/Staging Batches" clicking on the batch you want and clicking on button "view details for selected batch"
in order to do the same thing with API (get error codes), you'll need to get back the batch after it is inserted. 


//get information related to a staging batch
 public Collection<StagingBatch> StagingGet(Collection<Identifier> stagingBatch, bool ReturnAllCriteria, bool ReturnMembers, bool ReturnAttributes, bool ReturnRelationShips, ref OperationResult or)
 {
 Collection<StagingUnbatchedInformation> colUnbatched = new Collection<StagingUnbatchedInformation>();
 Collection<StagingBatch> colBatches = new Collection<StagingBatch>();
 using (ServiceClient c = MDS_WSConnect.CreateMdsProxy())
 {
 or = new OperationResult();
 colBatches = c.StagingGet(new International(), true, new StagingResultCriteria() { All = ReturnAllCriteria, Attributes = ReturnAttributes, Members = ReturnMembers, Relationships = ReturnRelationShips },
 new StagingSearchCriteria() { StagingBatches = stagingBatch, StagingDataStatus= StagingDataStatus.All }, out or, out colUnbatched);
 List<string> lstErr = new List<string>();
//...do what you need with the error collection
foreach (<strong>StagingBatchError err in colBatches.First().Errors</strong>)
{
 lstErr.Add(err.ErrorCode + " - " + err.TargetCode);
 }

 return colBatches;
 }
 }
so, complete process would be:

DateTime dtBefore = DateTime.Now; 
OperationResult or = new OperationResult();
  //filling new staging batch with entityMembers
  Collection<Identifier> colStaging = ModelMembersBulkMerge(colEntMembers);
  //initiating the staging process (not sure I really need that here in fact)
  Collection<StagingBatch> colBatches = StagingGet(colStaging, true, true, true, false, ref or);
  //triggering staging
  ProcessUnbatchedStaging(pModelId, pVersionId);

  DateTime dtAfter = DateTime.Now;
  TimeSpan ts = dtAfter.Subtract(dtBefore);

  MessageBox.Show("members (bulk) inserted : " + colEntMembers.First().Members.Count() + "\r\n" + "time elapsed (seconds):" + ts.TotalSeconds.ToString());
  //get back the batch to see if any errors 
  
  colBatches = StagingGet(colStaging, true, true, true, false, ref or);
note: StagingDataStatus= StagingDataStatus.All --> get all including Errors