Integration Manager – Unable to cast COM object of type ‘MSScriptControl.ErrorClass’ to interface type ‘MSScriptControl.IScriptError’.

Integration Manager – Error message. 
DOC 1 ERROR: Unable to cast COM object of type ‘MSScriptControl.ErrorClass’ to interface type ‘MSScriptControl.IScriptError’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{70841C78-067D-11D0-95D8-00A02463AB28}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
DOC 1 ERROR: Argument ‘Number’ is not a valid value. – Argument ‘Number’ is not a valid value.
DOC 1 ERROR: Unable to cast COM object of type ‘MSScriptControl.ErrorClass’ to interface type ‘MSScriptControl.IScriptError’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{70841C78-067D-11D0-95D8-00A02463AB28}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Solution : regsvr32  c:\windows\system32\msscript.ocx

Cheers!

Sanjay

 

 

Electronic Bank Reconcile – Dates won’t import properly

06/17/2016 – Today was setting up configuration for electronic bank reconcile and every time  the download of the statement was done the date imported into the system was either 1/1/1900 or 12/31/9999.  After several un successful attempts to fix the issue finally  the eureka moment…  The excel source file had a hidden column and the copy paste to text file added an invisible column which shifted all columns to the right messing the mapping!  The lesson learnt here is, check the source file in text editor …

Cheers!
Sanjay

 

 

VAST to GP intergration

VAST staging area:

SELECT     TOP (200) IDENTITYFIELD, COMPANY_NUMBER, GL_NUMBER, TRANSACTION_DATE, DOCUMENT_NUMBER, CUSTOMER_NAME, DEBIT, CREDIT, SOURCE, 
                      GL_TYPE, STATUS, WDATE, IDATE, WRITEROUTINE, CUSTOMER_TYPE, COMPOUND_GL_NUMBER, SEND_TO_THIRDPARTY, JOURNAL_NUM, GUID, COMMENT, 
                      WORKORDER, WORKORDER_LINE_ID, Goodyear_Claim_No, REF_Doc_ID, BIG_Invoice_No, REF_Order_Type, PARENT_GUID, Eod_Status, Eod_DateStamp, 
                      DO_NOT_SEND_VENDOR
FROM         GLTRANSACTION

 

VAST Staging area to GP Resend:

UPDATE GLTRANSACTION SET SEND_TO_THIRDPARTY = 1 WHERE  (TRANSACTION_DATE = CONVERT(DATETIME, '2016-05-05 00:00:00', 102))

Cheers!
Sanjay

SharePoint 2013 AD Group Sync

To Manage SharePoint Security using active directory security group couple of configuration setting needs to be configured.

  1. SharePoint default setting for caching AD Security Group membership is 24 hours or 1440 minutes.  When testing how the AD Security works in share point 24 hours is to long.  Set it to 2 minutes at share point admin power shell.
    stsadm.exe -o setproperty -propertyname token-timeout -propertyvalue 2
  2. The next setting deals with users who have already logged in before the above setting change is made.  These setting relate to the security token life time setting and security token cache expiration.  The default setting is 10 hours, again it to long for testing how security works – set it to 2 minutes at share point admin power shell.
    sts = Get-SPSecurityTokenServiceConfig
    $sts.FormsTokenLifetime = (New-TimeSpan -minutes 2)
    $sts.WindowsTokenLifetime = (New-TimeSpan -minutes 2)
    $sts.LogonTokenCacheExpirationWindow = (New-TimeSpan -minutes 1)
    $sts.Update()
  3. Note the Cache expiration time should be less than token life time!  Revert back to default setting once the effects of group membership setting are studied!!

With these setting SharePoint permission based on active directory security groups will sync with group membership changes in 2 minutes.

Cheers!
Sanjay

 

 

 

 

 

 

Infopath web form – print preview – turn off header footer on print

1. Print preview for web forms is enabled at form options.
>> Info >> Form Options >> Web browser >> Check mark the print preview

2. Publish the form.

3. Open the form in web browser and click print preview

4. The form open in Internet explorer (my default browser)

5. At the browser, click on printer icon and print preview.

6. The IE preview window opens where there is a option to turn off or tune on the browser headers or footers.

7: By redirecting the print to a PDF printer, a PDF copy of the form can be generated.

Cheers!
Sanjay

 

Increase Infopath file control upload size.

The file size of the attachment is control is related to size of user session state data size which by default is set to 4096 MB in share point 2013. Increasing the user session data size allows to increase the upload file size. The setting can be done at:

Central Administration
General Application Settings
Configure InfoPath forms services
User Sessions
Maximum size of user session data

Cheers!
Sanjay

User profile service – FieldProfileName

UserProfile_GUID
AccountName
FirstName
LastName
PreferredName
WorkPhone
Office
Department
Title
Manager
AboutMe
PersonalSpace
PictureURL
UserName
QuickLinks
WebSite
PublicSiteRedirect
SPS-Dotted-line
SPS-Peers
SPS-Responsibility
SPS-Skills
SPS-PastProjects
SPS-Interests
SPS-School
SPS-SipAddress
SPS-Birthday
SPS-MySiteUpgrade
SPS-DontSuggestList
SPS-ProxyAddresses
SPS-HireDate
SPS-LastColleagueAdded
SPS-OWAUrl
SPS-ResourceAccountName
SPS-MasterAccountName
Assistant
WorkEmail
CellPhone
Fax
HomePhone

Part 7: Logging the SSIS package events to a dynamically named csv file

Part 7: Logging the SSIS package events to a dynamically named csv file

  1. Right click on the surface area of control flow tab of SSIS package and select logging.ScreenShot027
  2. Select SSIS Log providers for text files:ScreenShot028
  3. On details table select even which needs to be logged:ScreenShot029
  4. Open the connection manager properties for the SSIS log providerScreenShot031
  5. Update connection string property to set every time during run timeScreenShot032
  6. with following script:
    "F:\\SFTP\\Logs\\"+  @[System::PackageName] + 
    (DT_STR,4,1252)DATEPART( "yyyy" , @[System::StartTime]   ) + 
    RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" ,  @[System::StartTime]  ), 2) + 
    RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , @[System::StartTime]   ), 2) + 
    RIGHT("0" + (DT_STR,4,1252)DATEPART( "hh" , @[System::StartTime]   ), 2) + 
    RIGHT("0" + (DT_STR,4,1252)DATEPART( "mi" ,  @[System::StartTime]  ), 2) + 
    RIGHT("0" + (DT_STR,4,1252)DATEPART( "ss" , @[System::StartTime]   ), 2) + 
    ".csv"

 
Save the package, now the SSIs package will save logs to text file for every execution.
 
See Also:
Part 1 : Automate SFTP file operation using SSIS
Part 2 : Setting up Free SFTP Server
Part 3 : Testing the SFTP Server from a client
Part 4 : Creating a SSIS Package to automate SFTP File operations
Part 5 : Scheduling the SSIS Package
Part 6 : Save SFTP incoming files info to SQL table
Part 7 : Logging SSIS Package

Cheers!
sANJAY

Delete a Subsite from Sharepoint 2013

Delete a Sub Site from Sharepoint 2013

  1. Log on the parent site
  2. Click on the gear icon at the top left corner
  3. Click on site settings
  4. Click on Site Administration > Sites and workspace
  5. All sub-sites are listed, delete the sub site button is listed at end of each sub site listing.

Cheers!

Sanjay