sql

11 Topics

'OpenApiConnection' is not valid
Hi everyone, I am new to power automate, l am trying to migrate data from a SQL table to a SharePoint list using power automate, one of the fields keeps throwing an openApiconnection error. it is a lookup field in SharePoint however in Microsoft flow it's expecting a lookup ID of the field. how do l go round solving it, please..... The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Project/Id' is required to be of type 'Integer/int64'. The runtime value '"743: Carefirst replacement / Eclipse - Phase 1: Adults"' to be converted doesn't have the expected format 'Integer/int64'.
KeithMontana
Mar 28, 2022 Place SharePoint
20KViews
0likes
1Comment
Use SQL database values in Sharepoint Custom Forms
Hi everyone, I managed to use a PowerApps custom form to create dynamic dropdowns with my SQL data and the results appear in the dropdowns but when I submit the form only those SQL values show up as invisible (all other non-SQL fields show up fine). I'm using [DB_Name].Customers or Sort(Distinct([DB_Name], Customers), Result) to get the SQL information, but it's just not submitting properly. Is this a problem related to the form's connection to the server? Is there a solution to this issue? Thanks in advance,
CodeFox
Oct 20, 2021 Place SharePoint
717Views
0likes
0Comments
What is the best way to use SQL on-premise data within SharePoint Online?
We would like to create a solution in SharePoint Online that can perform CRUD operations on data in an on-premise SQL database. What is the best way to accomplish this? What are the different options? Is it possible to do this from a SharePoint Framework web part?
kevinmckeown8
May 11, 2021 Place SharePoint
1.2KViews
0likes
2Comments
Is this a good SharePoint SQL Backup and Maintenance Plan Strategy?
Hi all Looking for some guidance. Setting up SharePoint SQL Backups for the first time and maintenance plans. Is this a good strategy in general even if there is no company policy yet defined? Environment has 2 SQLs VMs on a Microsoft Failover Cluster hosted split over 2 ESXi hosts connected to a SAN. (Cluster Shared Volume in use for SQL Data, SQl Log and SQL Backup volume). General DB Maintenance Task Check Database Integrity (All databases include indexes) Rebuild indexes (All databases, tables, views, orig amount of free space) Update Statistics Task (Full scan all DB and tables and views, existing statistics) History Clean Up Task (Backup Job and Maintenance plan. Age older than 4 weeks) Maintenance Cleanup of Reports (Age older than 4 weeks) 12:01AM Sunday Full Backup - (compress, backup set expires after 14 days). Databases (All) Weekly - 1AM Sunday Differential Backup - (compress, backup set expires after 7 days) Databases (All except Master and Tempdb) Daily - 2AM excl Sunday Transaction Backup - (compress, backup set expires after 1 day) Databases (Content, SharePoint_Config and SharePoint_AdminContent) Daily - Every 15 Minutes Full Backup cleanup Weekly - 2:30AM Sunday Diff Backup cleanup Weekly - 3AM Sunday Log backup cleanup Daily - 4 AM
Gerry_Morley
Apr 15, 2021 Place SharePoint
485Views
0likes
0Comments
SharePoint 2013 - Remote Blob Storage and Deduplication / Shredded Storage Migration
Hi there, i only found 2 blogs mentioning that this is possible. But is it also supported? Anyone is using this configuration? I want to move most of our sitecollections "to" Remote Blob Storage. I already set it up on our DEV Server but not yet on our test server. But i do not find that much about performance and support of deduplicating the BLOB drive. Also - how can i change the shred size of existing files? At the moment they are set to the 64k design size. Best regards Stephan
Stephan G
Jan 27, 2019 Place SharePoint
4.6KViews
0likes
13Comments
Script to remove disabled users from SharePoint2013
We have SP2013. We had some users leave the organization. They have been disabled in AD however they are still present on SharePoint. Is there any easier way to remove these users who are disabled in AD to be removed from Sharepoint also? Any script which will help me? thank you !!
Test SharePoint
Nov 12, 2018 Place SharePoint
2.3KViews
0likes
2Comments
Powershell script fo deleting specific-files-from-sharepoint-on-premises-library error
I was going through article: http://romeodonca.com/deleting-specific-files-from-sharepoint-on-premises-library I am getting an issue in implementing it. can you please have a look intothe following scenario: I tried the 1st script. it runs successfully however the files dont get deleted. for eg: my Site URL: http://contoso.com/subsitename Library name: library Filename: test If you open my csv file, you will see the following list of URL's: http://contoso.com/subsitename/library/New%20Text%20Document%20-%20Copy.txt http://contoso.com/subsitename/library/New%20Text%20Document.txt http://contoso.com/subsitename/library/New%20Text%20Document%20-%20Copy%20(2).txt http://contoso.com/subsitename/library/New%20Text%20Document%20-%20Copy%20(3).txt Please let me know whether I have to insert any column title in the csv or the above is just fine? So My first script becomes: param( [Parameter(Mandatory=$true,HelpMessage=”http://contoso.com/subsitename”)][string]$SiteUrl, [Parameter(Mandatory=$true,HelpMessage=”library”)][string]$LibraryName, [Parameter(Mandatory=$true,HelpMessage=”test”)][string]$Filename ) Add-PSSnapin microsoft.sharepoint.powershell ###################################### parse all items function deleting($mylist,$yoursourcefile) { $files = @() foreach ($searchedfile in (Import-Csv $yoursourcefile)) { #$myweb = get-spweb (($searchedfile.url).split(‘/’)[0]+”//”+$searchedfile.url.split(‘/’)[2]) #$mylist = $myweb.Lists | Where-Object {$_.Title -match ($searchedfile.url).split(‘/’)[3]} foreach ($file in $mylist.items) { if (($searchedfile.url) -eq (($searchedfile.url).split(‘/’)[0]+”//”+($searchedfile.url).split(‘/’)[2]+”/”+$file.url)) { “Deleting: ” + $searchedfile.url $files = $files + $file break } } } foreach ($item in $files) { $item.Delete() } } the above script runs however the files dont get deleted. I am not sure What wrong. I tried doing the CAML Query. And I get the following errors with different inputs: 1)>>>>You cannot call a method on a null-valued expression. At line:13 char:9 + $file = $mylist.GetItems($query) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull 2)>>>>>You cannot call a method on a null-valued expression. At line:18 char:9 + $item.Delete() + ~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull 3)>>>>>deleting : The term 'deleting' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:39 char:21 + deleting $mylist $filename + ~~~~~~~~ + CategoryInfo : ObjectNotFound: (deleting:String) [], CommandNot FoundException + FullyQualifiedErrorId : CommandNotFoundException 4)>>>>Import-Csv : Cannot validate argument on parameter 'Path'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again. At line:4 char:43 + foreach ($searchedfile in (Import-Csv $test)) + ~~~~ + CategoryInfo : InvalidData: (:) [Import-Csv], ParameterBindingV alidationException + FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.Power Shell.Commands.ImportCsvCommand Can you please help me out in this. i am not sure what I am missing. How will the script turn out if I have the following inputs with me: my Site URL: http://contoso.com/subsitename Library name: library Filename: test csv file: http://contoso.com/subsitename/library/New%20Text%20Document%20-%20Copy.txt http://contoso.com/subsitename/library/New%20Text%20Document.txt http://contoso.com/subsitename/library/New%20Text%20Document%20-%20Copy%20(2).txt http://contoso.com/subsitename/library/New%20Text%20Document%20-%20Copy%20(3).txt I would really appreciate help on this!! thanks again
Solved
Test SharePoint
Oct 31, 2018 Place SharePoint
19KViews
0likes
4Comments
Application pool keeps on stopping
One of my Application pool keeps on stopping which is impacting my User Profile Service Application and Workflow management service on SharePoint Server 2013. I have followed the below steps: Click on Application pools. Click on the particular Application pool for your site. Right-click Advanced settings. Set Enable 32-Bit Applications to False. Also I have found that below steps might help also: Restart the application pool IIS reset Stop Start User Profile Service However is there anything else that I can do which will not impact the Business?
Test SharePoint
Jul 31, 2018 Place SharePoint
61KViews
0likes
3Comments
How do I know which user is hitting a particular SQL Server on my SharePoint Server?
Hello, I need to understand which user is hitting a particular SQL Server on my SharePoint Server? Also which web service is being hit? Also which app service is being hit? I checked the Central admin > Upgrade and migration > Review Database Status for connected db's however that can be the aliases too right? Thanks.
Solved
Test SharePoint
Jul 19, 2018 Place SharePoint
1.9KViews
0likes
4Comments
Error while creating new SP Site collection 2013
When I try to create a new site collection in a web application, it gives the error: Sorry, something went wrong This page has encountered a critical error. Contact your system administrator if this problem persists. A couple of days back, I had changed the settings in Monitoring>when it showed me that content db is growing large, I had clicked on repair automatically which might have stopped me from creating new site collections. Any one know how to revert this settings? I checked the uls logs and it showed me: Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.SharePoint.WebPartPages.WebPartPageUserException: This page has encountered a critical error. Contact your system administrator if this problem persists. at Microsoft.SharePoint.ApplicationRuntime.SafeControls.IsSafeControl(Boolean isAppWeb, Type type, String& unsafeErrorMessage) at Microsoft.SharePoint.WebPartPages.TypeCache.CheckIfSafeControl(Type type, Boolean isAppWeb) at Microsoft.SharePoint.WebPartPages.TypeCache.get_Item(Type type, Boolean isAppWeb, Boolean disableSafeControlsCheck) at Microsoft.SharePoint.WebPartPages.WebPart.WriteXmlGlobal(Boolean disableSafeControlsCheck) at Microsoft.SharePoint.WebPartPages.BinaryWebPartSerializer.Serialize(SerializationMode mode, BinaryWebPartSerializerFlag binaryWebPartSerializerFlags, SPSerializationBinderBase serializationBinder, BinaryWebPartSerializerWriter writer) at Microsoft.SharePoint.WebPartPages.BinaryWebPartSerializer.Serialize(SerializationMode mode, BinaryWebPartSerializerFlag binaryWebPartSerializerFlags, SPSerializationBinderBase serializationBinder) at Microsoft.SharePoint.WebPartPages.SPWebPartManager.AddWebPartToStore(WebPart webPart, Int32 viewId, String viewGuid) at Microsoft.SharePoint.WebPartPages.SPWebPartManager.AddWebPartInternal(SPSupersetWebPart superset, Boolean throwIfLocked) at Microsoft.SharePoint.WebPartPages.SPLimitedWebPartManager.AddWebPart(WebPart webPart, String zoneId, Int32 zoneIndex) at Microsoft.Office.DocumentManagement.Internal.DocumentSetFeatureReceiver.FeatureActivated(SPFeatureReceiverProperties properties) at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce) at Microsoft.SharePoint.SPFeature.Activate(SPSite siteParent, SPWeb webParent, SPFeaturePropertyCollection props, SPFeatureActivateFlags activateFlags, Boolean fForce) at Microsoft.SharePoint.SPFeatureCollection.AddInternal(SPFeatureDefinition featdef, Version version, SPFeaturePropertyCollection properties, SPFeatureActivateFlags activateFlags, Boolean force, Boolean fMarkOnly) at Microsoft.SharePoint.SPFeatureCollection.AddInternalWithName(Guid featureId, Int32 compatibilityLevel, String featureName, Version version, SPFeaturePropertyCollection properties, SPFeatureActivateFlags activateFlags, Boolean force, Boolean fMarkOnly, Boolean fIgnoreMissing, SPFeatureDefinitionScope featdefScope) at Microsoft.SharePoint.SPFeatureCollection.AddInternal(Guid featureId, Version version, SPFeaturePropertyCollection properties, Boolean force, Boolean fMarkOnly, SPFeatureDefinitionScope featdefScope) at Microsoft.Office.DocumentManagement.VideoAndRichMedia.Internal.VideoAndRichMediaFeatureReceiver.FeatureActivated(SPFeatureReceiverProperties properties) at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce) at Microsoft.SharePoint.SPFeature.Activate(SPSite siteParent, SPWeb webParent, SPFeaturePropertyCollection props, SPFeatureActivateFlags activateFlags, Boolean fForce) at Microsoft.SharePoint.SPFeatureCollection.AddInternal(SPFeatureDefinition featdef, Version version, SPFeaturePropertyCollection properties, SPFeatureActivateFlags activateFlags, Boolean force, Boolean fMarkOnly) at Microsoft.SharePoint.SPTemplateAssociationElement.EnsureTemplateAssociatedSiteFeaturesActivated(SPSite site, String sTemplateName) at Microsoft.SharePoint.SPFeatureManager.<>c__DisplayClass16.<EnsureTemplateAssociatedSiteFeaturesActivated>b__15() at Microsoft.SharePoint.SPSecurity.RunAsUser(SPUserToken userToken, Boolean bResetContext, WaitCallback code, Object param) at Microsoft.SharePoint.SPFeatureManager.EnsureTemplateAssociatedSiteFeaturesActivated(Byte[]& userToken, Guid& tranLockerId, Int32 nZone, Guid databaseid, Guid siteid, String sTemplateName) at Microsoft.SharePoint.Library.SPRequestInternalClass.ApplyWebTemplate(String bstrUrl, String bstrWebTemplateContent, Int32 fWebTemplateContentFromSubweb, Int32 fDeleteGlobalListsWithWebTemplateContent, Int32 fIgnoreMissingFeatures, String& bstrWebTemplate, Int32& plWebTemplateId) at Microsoft.SharePoint.Library.SPRequest.ApplyWebTemplate(String bstrUrl, String bstrWebTemplateContent, Int32 fWebTemplateContentFromSubweb, Int32 fDeleteGlobalListsWithWebTemplateContent, Int32 fIgnoreMissingFeatures, String& bstrWebTemplate, Int32& plWebTemplateId) at Microsoft.SharePoint.SPWeb.ProvisionWebTemplate(SPWebTemplate webTemplate, String webTemplateToUse, SPFeatureWebTemplate featureWebTemplate, Page page, SPFeatureDependencyErrorBehavior featureDependencyErrorBehavior, ICollection`1& featureDependencyErrors) at Microsoft.SharePoint.SPWeb.ApplyWebTemplate(SPWebTemplate webTemplate, Page page, SPFeatureDependencyErrorBehavior featureDependencyErrorBehavior, ICollection`1& featureDependencyErrors) at Microsoft.SharePoint.ApplicationPages.TemplatePickerUtil.ApplyWebTemplateAndRedirect(SPSiteAdministration siteAdministration, String strWebTemplate, String strRedirect, Boolean bCreateDefaultGroups, Page page, Boolean bDeleteOnError) at Microsoft.SharePoint.ApplicationPages.CreateSitePage.BtnCreateSite_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Test SharePoint
Jul 18, 2018 Place SharePoint
5.2KViews
0likes
4Comments