Month: June 2024
Data Hashing Issue
We are trying to insert the data from temp table to main table in SQL server. We have encountered the below issue While hashing the data.
Please find the attached query used for insertion and received the below mentioned error message.
INSERT INTO hash2(email) (SELECT CDWH_REP.DBO.UDF_HASHBYTES(‘SHA256’,email) as email from hash1)
USE [CD_REP]
GO
/****** Object: SqlAssembly [hashCLR] Script Date: 6/20/2024 9:12:06 AM ******/
CREATE ASSEMBLY [cryptohashCLR]
from (hashing_value)
WITH PERMISSION_SET = SAFE
GO
USE [CD_REP]
GO
/****** Object: UserDefinedFunction [dbo].[udf_hashBytes] Script Date: 6/20/2024 9:12:45 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION [dbo].[udf_hash](@hashtype [nvarchar](max), @input [nvarchar](max))
RETURNS [nvarchar](max) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [cryptohashCLR].[cryptohashCLR.SqlHash].[CLRHash]
GO
Note- We can successfully execute the same query in prod.
Msg 6522, Level 16, State 1, Line 4
A .NET Framework error occurred during execution of user-defined routine or aggregate “udf_hashBytes”:
System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.
The protected resources (only available with full trust) were: All
The demanded resources were: MayLeakOnAbort
System.Security.HostProtectionException:
at System.RuntimeMethodHandle.PerformSecurityCheck(Object obj, RuntimeMethodHandleInternal method, RuntimeType parent, UInt32 invocationFlags)
at System.RuntimeMethodHandle.PerformSecurityCheck(Object obj, IRuntimeMethodInfo method, RuntimeType parent, UInt32 invocationFlags)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Security.Cryptography.CryptoConfig.CreateFromName(String name, Object[] args)
at System.Security.Cryptography.SHA256Managed..ctor()
at cryptohashCLR.SqlHash.CLRHash(SqlString hashtype, SqlString input)
.
The statement has been terminated.
We are trying to insert the data from temp table to main table in SQL server. We have encountered the below issue While hashing the data.Please find the attached query used for insertion and received the below mentioned error message. INSERT INTO hash2(email) (SELECT CDWH_REP.DBO.UDF_HASHBYTES(‘SHA256’,email) as email from hash1) USE [CD_REP]GO/****** Object: SqlAssembly [hashCLR] Script Date: 6/20/2024 9:12:06 AM ******/CREATE ASSEMBLY [cryptohashCLR]from (hashing_value)WITH PERMISSION_SET = SAFEGO USE [CD_REP]GO/****** Object: UserDefinedFunction [dbo].[udf_hashBytes] Script Date: 6/20/2024 9:12:45 AM ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER OFFGOCREATE FUNCTION [dbo].[udf_hash](@hashtype [nvarchar](max), @input [nvarchar](max))RETURNS [nvarchar](max) WITH EXECUTE AS CALLERASEXTERNAL NAME [cryptohashCLR].[cryptohashCLR.SqlHash].[CLRHash]GO Note- We can successfully execute the same query in prod. Msg 6522, Level 16, State 1, Line 4A .NET Framework error occurred during execution of user-defined routine or aggregate “udf_hashBytes”:System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.The protected resources (only available with full trust) were: AllThe demanded resources were: MayLeakOnAbortSystem.Security.HostProtectionException:at System.RuntimeMethodHandle.PerformSecurityCheck(Object obj, RuntimeMethodHandleInternal method, RuntimeType parent, UInt32 invocationFlags)at System.RuntimeMethodHandle.PerformSecurityCheck(Object obj, IRuntimeMethodInfo method, RuntimeType parent, UInt32 invocationFlags)at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)at System.Security.Cryptography.CryptoConfig.CreateFromName(String name, Object[] args)at System.Security.Cryptography.SHA256Managed..ctor()at cryptohashCLR.SqlHash.CLRHash(SqlString hashtype, SqlString input).The statement has been terminated. Read More
varible in link to another file or generating formula from a formula?
pc/office 10
excel version 2404
likely over my head again, but …
I need to generated formula in cells on worksheet to look at cells on other sheets.
I need to be able to paste list of part numbers, and generate the reference in each cell.
-pasting list in column a
all filenames/tabs/cell location will be pasted part number, plus the info contained in column p, labeled as suffix, (the last 2 digits ranging from 70 to 79, to represent columns B-K, labeled as op 10-100
the resulting desired formula is in column L, labeled as CONCAT results. from here, i would have to copy and paste qas the results, i do not want that step either
im sure there is a better way to do this …. is this even plausible?
pc/office 10excel version 2404 likely over my head again, but …I need to generated formula in cells on worksheet to look at cells on other sheets.I need to be able to paste list of part numbers, and generate the reference in each cell.-pasting list in column aall filenames/tabs/cell location will be pasted part number, plus the info contained in column p, labeled as suffix, (the last 2 digits ranging from 70 to 79, to represent columns B-K, labeled as op 10-100the resulting desired formula is in column L, labeled as CONCAT results. from here, i would have to copy and paste qas the results, i do not want that step eitherim sure there is a better way to do this …. is this even plausible? Read More
Project for the Web – “Failed to load baseline” error on read-only records
Hello dear community,
We have deployed Project for the Web, as well as the Project Accelerator, in a dedicated Dataverse environment. We customized it for our own PPM needs. All works well except an error related to the loading of the baseline when people with a read-only security role try open the Tasks tab of a project.
The message says “Failed to load baselines. Please try again later” with a correlation id.
It does not block other activities in the Tasks tab though.
We checked that they indeed get access through the expected security role. We then experimented changing the permissions:
Grant write permission on the 2 baseline related tables (Project Baseline Data, Project Baseline Task Data) => No change. We reverted to read-only on those two table.Grant write permission on the Project table => This resolves the problem
For information, we created that security role by copying the Project User role and grant only read permissions on all assigned table for the “Parent: Child Business Unit”.
Though this indeed seems to resolve the problem, it does not constitute a valid solution since granting unwanted write access.
Has any of you encountered similar issues?
Best regards,
Pascal
Hello dear community, We have deployed Project for the Web, as well as the Project Accelerator, in a dedicated Dataverse environment. We customized it for our own PPM needs. All works well except an error related to the loading of the baseline when people with a read-only security role try open the Tasks tab of a project. The message says “Failed to load baselines. Please try again later” with a correlation id. It does not block other activities in the Tasks tab though.We checked that they indeed get access through the expected security role. We then experimented changing the permissions:Grant write permission on the 2 baseline related tables (Project Baseline Data, Project Baseline Task Data) => No change. We reverted to read-only on those two table.Grant write permission on the Project table => This resolves the problemFor information, we created that security role by copying the Project User role and grant only read permissions on all assigned table for the “Parent: Child Business Unit”. Though this indeed seems to resolve the problem, it does not constitute a valid solution since granting unwanted write access. Has any of you encountered similar issues? Best regards,Pascal Read More
Admin account not recognised as admin
I have a machine that is joined to Intune/Entra, and it looks like it has been joined up correctly and is fully compliant with policies we have in place.
The issue I’m having is that when I run a program as administrator, it comes back with the message that “The requested operation requires elevation”, as if the account is not the admin. However, I know that the account works as admin on every other machine in my tenant and is the admin account I used to enroll this machine into my tenant.
Its a Windows 10 22H2 machine, that I am now looking to upgrade to Win 11, that I had to restore the OS on using the Dell Support Recovery platform.
Any help is greatly appreciated.
I have a machine that is joined to Intune/Entra, and it looks like it has been joined up correctly and is fully compliant with policies we have in place. The issue I’m having is that when I run a program as administrator, it comes back with the message that “The requested operation requires elevation”, as if the account is not the admin. However, I know that the account works as admin on every other machine in my tenant and is the admin account I used to enroll this machine into my tenant. Its a Windows 10 22H2 machine, that I am now looking to upgrade to Win 11, that I had to restore the OS on using the Dell Support Recovery platform. Any help is greatly appreciated. Read More
Disable the captions on Stream videos at the tenant level
I don’t know if this has been asked before but I’ve been asked if captions can defaulted to being turned “off” for any videos uploaded to Stream as at the moment they are defaulted to be turned on.
Can I do this at the tenant level? I haven’t seen it been asked online and just want to see if it is possible.
Any help or guidance would be greatly apricated!
I don’t know if this has been asked before but I’ve been asked if captions can defaulted to being turned “off” for any videos uploaded to Stream as at the moment they are defaulted to be turned on. Can I do this at the tenant level? I haven’t seen it been asked online and just want to see if it is possible. Any help or guidance would be greatly apricated! Read More
Counting within 3 columns
Hi, not feeling too smart here. How do I code Excel to make the result table below, counting number of unique occurrences of fruit types across 3 columns? Col1 etc refer to Table columns in DataTable in the Data sheet. So I presume the array to count in is Data!DataTable[[Col1]:[Col3]] or something like that? And not sure what function to use. Thank you.
Hi, not feeling too smart here. How do I code Excel to make the result table below, counting number of unique occurrences of fruit types across 3 columns? Col1 etc refer to Table columns in DataTable in the Data sheet. So I presume the array to count in is Data!DataTable[[Col1]:[Col3]] or something like that? And not sure what function to use. Thank you. Read More
Purview Data Quality Connection MSI Only?
I am getting an issue connecting the new portal for Data Quality as MSFT is forcing the use of a Managed Identify (MSI), even though i have already connected the data source with SQL Authentication for the scanning. I a unable to connect as Purview is confused in the purview resource name, as there is another Azure resource with same name. I think I have to recreate my purview instance to resolve this managed identity lock.
It would be preferable if MSFT would allow the same credentials for DQ as it does for scanning.
I am getting an issue connecting the new portal for Data Quality as MSFT is forcing the use of a Managed Identify (MSI), even though i have already connected the data source with SQL Authentication for the scanning. I a unable to connect as Purview is confused in the purview resource name, as there is another Azure resource with same name. I think I have to recreate my purview instance to resolve this managed identity lock. It would be preferable if MSFT would allow the same credentials for DQ as it does for scanning. Read More
Co-Pilot for Service Dynamics 365
I am currently trying to set up Co-Pilot for Service to link with my Dyncmis 365 application. I am trying to create cases/incidents from my Outlook extension and it is showing the following error:
{ “errorCodeName”: “Microsoft.SalesProductivity.ServiceFramework.SPServiceCustomErrorCode.UnidentifiedError”, “message”: “Copy the error details here, then share them with your admin or Microsoft support and ask if they can help you resolve this issue.”, “title”: “Something went wrong”, “properties”: {}, “troubleshootingLink”: null, “source”: “Server”, “sessionId”: “c1be7da0-0af3-4037-861e-5f1ec5054ab6”, “activityId”: “09a3b360-b3d3-41dd-9778-061719985467” }
Any thoughts?
I am currently trying to set up Co-Pilot for Service to link with my Dyncmis 365 application. I am trying to create cases/incidents from my Outlook extension and it is showing the following error: { “errorCodeName”: “Microsoft.SalesProductivity.ServiceFramework.SPServiceCustomErrorCode.UnidentifiedError”, “message”: “Copy the error details here, then share them with your admin or Microsoft support and ask if they can help you resolve this issue.”, “title”: “Something went wrong”, “properties”: {}, “troubleshootingLink”: null, “source”: “Server”, “sessionId”: “c1be7da0-0af3-4037-861e-5f1ec5054ab6”, “activityId”: “09a3b360-b3d3-41dd-9778-061719985467” } Any thoughts? Read More
Build HDF5 Filter Plugins on Linux Using MATLAB HDF5 Shared Library or GNU Export Map
How do I build HDF5 Filter Plugins on Linux Using MATLAB HDF5 Shared Library or GNU Export Map?How do I build HDF5 Filter Plugins on Linux Using MATLAB HDF5 Shared Library or GNU Export Map? How do I build HDF5 Filter Plugins on Linux Using MATLAB HDF5 Shared Library or GNU Export Map? MATLAB Answers — New Questions
why my course is showing no resources available
why my course is showing no resources availablewhy my course is showing no resources available why my course is showing no resources available why my course is showing no resources available MATLAB Answers — New Questions
Plotting error bars on curve
Hello,
I have code that compares two devices and I am plotting the error on y-axis throughout a gait cycle % (on the x axis).
I am trying to get the error bars to plot the standard error but I am having an unexpected result when plotting the curve.
This is the code I am working with.
Initially x, ave_diff and SE are 1X1000 and I would like to plot it over a gait cycle from 0-100% hence why I have resampled the signals.
However, when I run this code I have extra values at the end of the plot, yet the resmapled variables are all 101X1?
I cannot spot my error and was wondering if someone my point me in the correct direction or suggest where my fault lies.
I have attached the curve and the area where the issue lies, you can see the standard error bars also become strange.
Thanks in advance
figure()
x = smooth(resample((gc),101,length(gc),’Dimension’,1));
ave_diff_resample = smooth(resample((ave_diff),101,length(ave_diff),’Dimension’,1));
SE_resampled = smooth(resample((SE),101,length(SE),’Dimension’,1));
set(gcf,’Color’,’w’);
%standard error plot
plot(x, ave_diff_resample,’-‘,’Color’,[0 0 0],’linewidth’,0.5)
hold on
% Adding error bars
errorbar(x, ave_diff_resample, SE_resampled, ‘vertical’);
hold on
hline = refline(0, 0);
hline.Color = ‘k’;
xlim([0 100]);
ylim([-15 15]);
legend(‘Signed Difference’, ‘Standard error bar’)
xlabel(‘Gait cycle %’)
ylabel(‘Difference (deg)’)Hello,
I have code that compares two devices and I am plotting the error on y-axis throughout a gait cycle % (on the x axis).
I am trying to get the error bars to plot the standard error but I am having an unexpected result when plotting the curve.
This is the code I am working with.
Initially x, ave_diff and SE are 1X1000 and I would like to plot it over a gait cycle from 0-100% hence why I have resampled the signals.
However, when I run this code I have extra values at the end of the plot, yet the resmapled variables are all 101X1?
I cannot spot my error and was wondering if someone my point me in the correct direction or suggest where my fault lies.
I have attached the curve and the area where the issue lies, you can see the standard error bars also become strange.
Thanks in advance
figure()
x = smooth(resample((gc),101,length(gc),’Dimension’,1));
ave_diff_resample = smooth(resample((ave_diff),101,length(ave_diff),’Dimension’,1));
SE_resampled = smooth(resample((SE),101,length(SE),’Dimension’,1));
set(gcf,’Color’,’w’);
%standard error plot
plot(x, ave_diff_resample,’-‘,’Color’,[0 0 0],’linewidth’,0.5)
hold on
% Adding error bars
errorbar(x, ave_diff_resample, SE_resampled, ‘vertical’);
hold on
hline = refline(0, 0);
hline.Color = ‘k’;
xlim([0 100]);
ylim([-15 15]);
legend(‘Signed Difference’, ‘Standard error bar’)
xlabel(‘Gait cycle %’)
ylabel(‘Difference (deg)’) Hello,
I have code that compares two devices and I am plotting the error on y-axis throughout a gait cycle % (on the x axis).
I am trying to get the error bars to plot the standard error but I am having an unexpected result when plotting the curve.
This is the code I am working with.
Initially x, ave_diff and SE are 1X1000 and I would like to plot it over a gait cycle from 0-100% hence why I have resampled the signals.
However, when I run this code I have extra values at the end of the plot, yet the resmapled variables are all 101X1?
I cannot spot my error and was wondering if someone my point me in the correct direction or suggest where my fault lies.
I have attached the curve and the area where the issue lies, you can see the standard error bars also become strange.
Thanks in advance
figure()
x = smooth(resample((gc),101,length(gc),’Dimension’,1));
ave_diff_resample = smooth(resample((ave_diff),101,length(ave_diff),’Dimension’,1));
SE_resampled = smooth(resample((SE),101,length(SE),’Dimension’,1));
set(gcf,’Color’,’w’);
%standard error plot
plot(x, ave_diff_resample,’-‘,’Color’,[0 0 0],’linewidth’,0.5)
hold on
% Adding error bars
errorbar(x, ave_diff_resample, SE_resampled, ‘vertical’);
hold on
hline = refline(0, 0);
hline.Color = ‘k’;
xlim([0 100]);
ylim([-15 15]);
legend(‘Signed Difference’, ‘Standard error bar’)
xlabel(‘Gait cycle %’)
ylabel(‘Difference (deg)’) error bars, curve plotting, resample data, plot MATLAB Answers — New Questions
Storage Spaces Direct bug?
Does anyone know if Microsoft monitors this forum for bug reports? Or is there a better way to report them?
I’m thinking there may be a bug in Windows Server 2025 Data Center when detecting supported drives for Storage Spaces Direct (S2D).
I’m using Micron 7450 Pro drives, which have Power Loss Protection (PLP) and should be supported, but the cluster report is incorrectly reporting they don’t have PLP and will not let them be used.
I posted this same issue a few weeks back on this forum, but didn’t get a response, so I’m thinking this is the wrong place to report the bug.
Does anyone know if Microsoft monitors this forum for bug reports? Or is there a better way to report them?I’m thinking there may be a bug in Windows Server 2025 Data Center when detecting supported drives for Storage Spaces Direct (S2D).I’m using Micron 7450 Pro drives, which have Power Loss Protection (PLP) and should be supported, but the cluster report is incorrectly reporting they don’t have PLP and will not let them be used. I posted this same issue a few weeks back on this forum, but didn’t get a response, so I’m thinking this is the wrong place to report the bug. Read More
How to Fix Quick-Books Runtime Error R6025 after update?
I’m experiencing a “Quick-Books Runtime Error R6025” when using my Quick-Books software. The error message mentions a “pure virtual function call.” What causes this error, and how can I troubleshoot and resolve it?
I’m experiencing a “Quick-Books Runtime Error R6025” when using my Quick-Books software. The error message mentions a “pure virtual function call.” What causes this error, and how can I troubleshoot and resolve it? Read More
Customer cant cancel or reschedule appointment
Multi-Person appointment. Im getting the confirmation email on another PC with no logged in Microsoft Account (same also on my main machine with incognito tab).
Customer clicks cancel and approves the popup that he’s sure. Gets an error essentially saying that a booking could not be made (when he tries to cancel).
When customer tries to reschedule he always gets
Meaning someone else was faster and took the timeslot. Which can’t be true since im the only person knowing so far of our bookings page, also I tried different times and even other staff.
High impact: Customer cant cancel or reschedule
Multi-Person appointment. Im getting the confirmation email on another PC with no logged in Microsoft Account (same also on my main machine with incognito tab). Customer clicks cancel and approves the popup that he’s sure. Gets an error essentially saying that a booking could not be made (when he tries to cancel).When customer tries to reschedule he always gets Meaning someone else was faster and took the timeslot. Which can’t be true since im the only person knowing so far of our bookings page, also I tried different times and even other staff. High impact: Customer cant cancel or reschedule Read More
Clean-up of Dormant account
Hi Team,
We would like to clean-up of Dormant accounts in Entra, any best practices or structural process available to take it as a guidance. this includes guests accounts with having P2 license.
Hi Team, We would like to clean-up of Dormant accounts in Entra, any best practices or structural process available to take it as a guidance. this includes guests accounts with having P2 license. Read More
Customer confirmation email missing company logo
Confirmation :
In cancellation email to customer its there …
Medium impact: ceo wont allow usage of tool until branding works.
Confirmation :In cancellation email to customer its there …Medium impact: ceo wont allow usage of tool until branding works. Read More
Azure Arc and Azure update manager
Hi
Wondered if anything can help.
I use Azure Update manager to patch my on-prem Windows servers. Recently several of them have starting failing, cant patch or do an assessment on them. They fail with the error “not able to run in specified time”
The VMs are definitely connected as I can see them online and heartbeat is active. The only thing I can spot in the activity log for one of the failing VMs is the “Read Azure Arc extensions” has been running for a long time and never seems to complete (See below). I guessing this is why the patching is failing as its queued up before this.
I’ve tried to remove the azure arc agent and re-install but this always comes back.
Does anyone have any ideas how to resolve this?
Hi Wondered if anything can help. I use Azure Update manager to patch my on-prem Windows servers. Recently several of them have starting failing, cant patch or do an assessment on them. They fail with the error “not able to run in specified time” The VMs are definitely connected as I can see them online and heartbeat is active. The only thing I can spot in the activity log for one of the failing VMs is the “Read Azure Arc extensions” has been running for a long time and never seems to complete (See below). I guessing this is why the patching is failing as its queued up before this. I’ve tried to remove the azure arc agent and re-install but this always comes back. Does anyone have any ideas how to resolve this? Read More
Cannot join meeting.
Hi, I have a trouble with teams.
Whenever I try to enter a meeting via a web link I get redirected to the calendar.
If I try to enter the meeting using code and password I still cannot enter the meeting, but instead of redirecting me to the calendar I got an error message instead.
Down in the bottom right corner, the message says “Cannot return null for non-nullable field AuthenticationUserProfile.upn”.
Can anybody help ?
Hi, I have a trouble with teams. Whenever I try to enter a meeting via a web link I get redirected to the calendar. If I try to enter the meeting using code and password I still cannot enter the meeting, but instead of redirecting me to the calendar I got an error message instead. Down in the bottom right corner, the message says “Cannot return null for non-nullable field AuthenticationUserProfile.upn”.Can anybody help ? Read More
How to fill in data automatically from one table to other if values matches
Hello,
I can’t seem to make a proper rule maybe someone could help me out?
My task is: I have two tables in same sheet. What I need is an information auto-fill into the columns if values matches from the other table.
Example: I have all the information in 1 Table, and i need a rule to auto-fill in second table if the values is the same in column B and G, then I need values to be taken from column C and D into columns H and I
Hello, I can’t seem to make a proper rule maybe someone could help me out? My task is: I have two tables in same sheet. What I need is an information auto-fill into the columns if values matches from the other table.Example: I have all the information in 1 Table, and i need a rule to auto-fill in second table if the values is the same in column B and G, then I need values to be taken from column C and D into columns H and I Read More
How to format a column with negative percentage numbers in RED
I would appreciate some guidance on how to format a column to showing “percentages” with negative numbers in RED.
This is the basic formular I use to calculate the percentages. =IF(B4=0,” “,+(B4/C4)-1), =IF(B5=0,” “,+(B5/C5)-1), etc… as below. The column Format Cells is set for Percentage. I would like any negative percentage values in the column to be shown in RED.
-20.92%
9.49%
28.53%
-29.14%
Thank you, Steve
I would appreciate some guidance on how to format a column to showing “percentages” with negative numbers in RED.This is the basic formular I use to calculate the percentages. =IF(B4=0,” “,+(B4/C4)-1), =IF(B5=0,” “,+(B5/C5)-1), etc… as below. The column Format Cells is set for Percentage. I would like any negative percentage values in the column to be shown in RED.-20.92%9.49%28.53%-29.14% Thank you, Steve Read More
