Category: News
How to remove/hide white space in SharePoint?
Hi, I’m new to SharePoint.
I wonder if the blank white space on our landing page/section can be removed? I’m stuck here :’) I’ve done some research, and there’s no out-of-the-box solution that can be used to hide this. However, I believe we can use CSS or something similar to solve this issue. Has anyone tried using a CSS injector to solve this? Would you mind sharing how to do this?
I’ve attached sample image below so that you can visualize it. Appreciate it if there is any help! Thanks
Hi, I’m new to SharePoint. I wonder if the blank white space on our landing page/section can be removed? I’m stuck here :’) I’ve done some research, and there’s no out-of-the-box solution that can be used to hide this. However, I believe we can use CSS or something similar to solve this issue. Has anyone tried using a CSS injector to solve this? Would you mind sharing how to do this? I’ve attached sample image below so that you can visualize it. Appreciate it if there is any help! Thanks Read More
How does the OverlapThreshold argument in balanceBoxLabels get passed along to the resulting blockLocationSet?
If balanceBoxLabels simply creates a blockLocationSet ("bSet"), how exactly does the OverlapThreshold argument/value specified in balanceBoxLabels get ‘passed along’ to the subsequent step of creating a boxLabelDatastore ("blds") based on the blockLocationSet, given that a blockLocationSet only contains the properties (1) Image number(s), (2) Block origin(s), (3) Block size and (4) Resolution level(s)?
For example, if I do:
bSet = balanceBoxLabels(boxLabels,blockedImages,blockSize,numObservations,OverlapThreshold=0.5)
This is supposed to specify that any bounding box that partially overlaps a block by >50% of the bounding box’s size gets cropped to the block boundary, while any bounding box that partially overlaps a block by <50% of the bounding box’s size gets discarded. So far, so good. But then when I do:
blds = boxLabelDatastore(boxLabels,bSet)
How does the OverlapThreshold value of 0.5 specified when creating "bSet" using BalanceBoxLabels get passed along to the creation of "blds" using boxLabelDatastore?If balanceBoxLabels simply creates a blockLocationSet ("bSet"), how exactly does the OverlapThreshold argument/value specified in balanceBoxLabels get ‘passed along’ to the subsequent step of creating a boxLabelDatastore ("blds") based on the blockLocationSet, given that a blockLocationSet only contains the properties (1) Image number(s), (2) Block origin(s), (3) Block size and (4) Resolution level(s)?
For example, if I do:
bSet = balanceBoxLabels(boxLabels,blockedImages,blockSize,numObservations,OverlapThreshold=0.5)
This is supposed to specify that any bounding box that partially overlaps a block by >50% of the bounding box’s size gets cropped to the block boundary, while any bounding box that partially overlaps a block by <50% of the bounding box’s size gets discarded. So far, so good. But then when I do:
blds = boxLabelDatastore(boxLabels,bSet)
How does the OverlapThreshold value of 0.5 specified when creating "bSet" using BalanceBoxLabels get passed along to the creation of "blds" using boxLabelDatastore? If balanceBoxLabels simply creates a blockLocationSet ("bSet"), how exactly does the OverlapThreshold argument/value specified in balanceBoxLabels get ‘passed along’ to the subsequent step of creating a boxLabelDatastore ("blds") based on the blockLocationSet, given that a blockLocationSet only contains the properties (1) Image number(s), (2) Block origin(s), (3) Block size and (4) Resolution level(s)?
For example, if I do:
bSet = balanceBoxLabels(boxLabels,blockedImages,blockSize,numObservations,OverlapThreshold=0.5)
This is supposed to specify that any bounding box that partially overlaps a block by >50% of the bounding box’s size gets cropped to the block boundary, while any bounding box that partially overlaps a block by <50% of the bounding box’s size gets discarded. So far, so good. But then when I do:
blds = boxLabelDatastore(boxLabels,bSet)
How does the OverlapThreshold value of 0.5 specified when creating "bSet" using BalanceBoxLabels get passed along to the creation of "blds" using boxLabelDatastore? deep learning, object detection, blocked images, box labels MATLAB Answers — New Questions
Different results from RL TD3 in MATLAB 2023a and 2024a
I am running the same Simulink model with the same RL agent and settings, but I get different results running it in MATLAB 2023a and MATLAB 2024a. while reapeating in the same MATLAB gives me the same results. Does anyone have any idea what is the reason and how can I fix it?I am running the same Simulink model with the same RL agent and settings, but I get different results running it in MATLAB 2023a and MATLAB 2024a. while reapeating in the same MATLAB gives me the same results. Does anyone have any idea what is the reason and how can I fix it? I am running the same Simulink model with the same RL agent and settings, but I get different results running it in MATLAB 2023a and MATLAB 2024a. while reapeating in the same MATLAB gives me the same results. Does anyone have any idea what is the reason and how can I fix it? rl, td3 MATLAB Answers — New Questions
Portion of code containing my custom functions is hidden and I cant access it.
So somehow my functions got hidden inside my script and there is the icon that should allow me to view everything that is hidden but for some reason it doesn’t. Is this a bug or is there a setting I might have changed by mistake? here is the icon I am talking about, I can’t click on it and I can see that there are roughly 300 lines of code that I can’t see so I know they are hidden there.So somehow my functions got hidden inside my script and there is the icon that should allow me to view everything that is hidden but for some reason it doesn’t. Is this a bug or is there a setting I might have changed by mistake? here is the icon I am talking about, I can’t click on it and I can see that there are roughly 300 lines of code that I can’t see so I know they are hidden there. So somehow my functions got hidden inside my script and there is the icon that should allow me to view everything that is hidden but for some reason it doesn’t. Is this a bug or is there a setting I might have changed by mistake? here is the icon I am talking about, I can’t click on it and I can see that there are roughly 300 lines of code that I can’t see so I know they are hidden there. functions, bug, matlab MATLAB Answers — New Questions
could you help me to add what is indicated in the pic?
Post Content Post Content legend, add legend MATLAB Answers — New Questions
I can’t get the result of exact dividing
syms m n x y a b D p0
Pmn= 16*p0/(pi^2*m*n);
b=2*a;
w(x,y)= 1/(D*pi^4)*symsum(symsum(Pmn/[(m^2/a^2)+(n^2/b^2)]^2*sin(m*pi*x/a)*sin(n*pi*y/b),n,1,5),m,1,5);
w(a/2,a)
I tried the get like this form;
I would appreciate any kind of suggestion, kind regards.syms m n x y a b D p0
Pmn= 16*p0/(pi^2*m*n);
b=2*a;
w(x,y)= 1/(D*pi^4)*symsum(symsum(Pmn/[(m^2/a^2)+(n^2/b^2)]^2*sin(m*pi*x/a)*sin(n*pi*y/b),n,1,5),m,1,5);
w(a/2,a)
I tried the get like this form;
I would appreciate any kind of suggestion, kind regards. syms m n x y a b D p0
Pmn= 16*p0/(pi^2*m*n);
b=2*a;
w(x,y)= 1/(D*pi^4)*symsum(symsum(Pmn/[(m^2/a^2)+(n^2/b^2)]^2*sin(m*pi*x/a)*sin(n*pi*y/b),n,1,5),m,1,5);
w(a/2,a)
I tried the get like this form;
I would appreciate any kind of suggestion, kind regards. dividing MATLAB Answers — New Questions
Missing text objects when exporting graphics in R2022b
Since upgrading to R2022b, I’ve repeatedly run into an inssue in which text objects, legends, titles, etc do not get printed, or their position is shifted significantly when I export graphics via exportgraphics or export_fig. I’m trying to find some sort of rhyme or reason, but the problem seems somewhat inconsistent. It may only occur with OpenGL, but I’m not entirely sure.
Is this a known problem? Is there a known fix?
I’m using a MacOS Monterey 12.6.1.Since upgrading to R2022b, I’ve repeatedly run into an inssue in which text objects, legends, titles, etc do not get printed, or their position is shifted significantly when I export graphics via exportgraphics or export_fig. I’m trying to find some sort of rhyme or reason, but the problem seems somewhat inconsistent. It may only occur with OpenGL, but I’m not entirely sure.
Is this a known problem? Is there a known fix?
I’m using a MacOS Monterey 12.6.1. Since upgrading to R2022b, I’ve repeatedly run into an inssue in which text objects, legends, titles, etc do not get printed, or their position is shifted significantly when I export graphics via exportgraphics or export_fig. I’m trying to find some sort of rhyme or reason, but the problem seems somewhat inconsistent. It may only occur with OpenGL, but I’m not entirely sure.
Is this a known problem? Is there a known fix?
I’m using a MacOS Monterey 12.6.1. exportgraphics, mac MATLAB Answers — New Questions
Findings the parameters from the time series
In the attached data file, there are two sheets, Sheet 1 and Sheet 2. Sheet 1 contains 4846 values of E or we can 4846 time series values. Sheet 2 contains the variables E, p(E), X, R1,R2, and R3.
Firstly I need to divide this 4846 values into different number of time series. As can be seen in Sheet 2, first time series has one row (or only the first value of E), second time series has 2 rows ( first and second value of E), third time series has 3 rows ( first, second and third value of E) and so on….i.e. each time a new E value is added. So at the end there will be 4846 different time series.
Basically I have to calculate R1, R2, and R3. Before that, p(E) and X is to be calculated. By clicking on each cell, the formula for calculating the variables will be visible. So basically, for each value of E, I will get R1,R2,and R3.Also, the first value of R1, R2 and R3 will be zero. You can start from the second time series.
I want to write the MATLAB code for the same by first dividing it into different time series and finally calculating R1,R2, and R3. This might be confusing. Ask any doubts for clarification.In the attached data file, there are two sheets, Sheet 1 and Sheet 2. Sheet 1 contains 4846 values of E or we can 4846 time series values. Sheet 2 contains the variables E, p(E), X, R1,R2, and R3.
Firstly I need to divide this 4846 values into different number of time series. As can be seen in Sheet 2, first time series has one row (or only the first value of E), second time series has 2 rows ( first and second value of E), third time series has 3 rows ( first, second and third value of E) and so on….i.e. each time a new E value is added. So at the end there will be 4846 different time series.
Basically I have to calculate R1, R2, and R3. Before that, p(E) and X is to be calculated. By clicking on each cell, the formula for calculating the variables will be visible. So basically, for each value of E, I will get R1,R2,and R3.Also, the first value of R1, R2 and R3 will be zero. You can start from the second time series.
I want to write the MATLAB code for the same by first dividing it into different time series and finally calculating R1,R2, and R3. This might be confusing. Ask any doubts for clarification. In the attached data file, there are two sheets, Sheet 1 and Sheet 2. Sheet 1 contains 4846 values of E or we can 4846 time series values. Sheet 2 contains the variables E, p(E), X, R1,R2, and R3.
Firstly I need to divide this 4846 values into different number of time series. As can be seen in Sheet 2, first time series has one row (or only the first value of E), second time series has 2 rows ( first and second value of E), third time series has 3 rows ( first, second and third value of E) and so on….i.e. each time a new E value is added. So at the end there will be 4846 different time series.
Basically I have to calculate R1, R2, and R3. Before that, p(E) and X is to be calculated. By clicking on each cell, the formula for calculating the variables will be visible. So basically, for each value of E, I will get R1,R2,and R3.Also, the first value of R1, R2 and R3 will be zero. You can start from the second time series.
I want to write the MATLAB code for the same by first dividing it into different time series and finally calculating R1,R2, and R3. This might be confusing. Ask any doubts for clarification. matlab MATLAB Answers — New Questions
Cannot find explicit solution
Hiii ,i need some help in matlab concerning programming pseudo Spectral method for Volterra equation i have all the script but when i check the solution i found i message error Warning: Cannot find explicit solution. > In solve (line 316) In HMM (line 350) La valeur numérique de x lorsque t = 0.0625 est :
can you help me pleaseHiii ,i need some help in matlab concerning programming pseudo Spectral method for Volterra equation i have all the script but when i check the solution i found i message error Warning: Cannot find explicit solution. > In solve (line 316) In HMM (line 350) La valeur numérique de x lorsque t = 0.0625 est :
can you help me please Hiii ,i need some help in matlab concerning programming pseudo Spectral method for Volterra equation i have all the script but when i check the solution i found i message error Warning: Cannot find explicit solution. > In solve (line 316) In HMM (line 350) La valeur numérique de x lorsque t = 0.0625 est :
can you help me please matlab, numerical integration, differential equations MATLAB Answers — New Questions
Error using lmi/kkt
I encountered a problem when I used KKT command. It always shows an error: ‘KKT system can only be derived for LPs or QPs’. I do not know the reason since I can run the same code on another computer. Someone suggests maybe the old version of LMI. I searched online and did not find how to add or update the LMI. I have attached my code below.
I hope someone could help. thank you!I encountered a problem when I used KKT command. It always shows an error: ‘KKT system can only be derived for LPs or QPs’. I do not know the reason since I can run the same code on another computer. Someone suggests maybe the old version of LMI. I searched online and did not find how to add or update the LMI. I have attached my code below.
I hope someone could help. thank you! I encountered a problem when I used KKT command. It always shows an error: ‘KKT system can only be derived for LPs or QPs’. I do not know the reason since I can run the same code on another computer. Someone suggests maybe the old version of LMI. I searched online and did not find how to add or update the LMI. I have attached my code below.
I hope someone could help. thank you! optimization, matlab MATLAB Answers — New Questions
What to Do When QuickBooks Automatic Backup not working
Troubleshooting QuickBooks Automatic Backup Not Working: Causes, Symptoms, and Solutions
QuickBooks Automatic Backup is a critical feature that helps safeguard your financial data by automatically creating backup copies of your company file. However, encountering issues where QuickBooks Automatic Backup is not working can be concerning for users. In this article, we’ll explore the possible reasons behind this problem, its symptoms, and effective solutions to ensure your data remains protected.
What is QuickBooks Automatic Backup?
QuickBooks Automatic Backup is a feature that allows users to schedule regular backups of their company file without manual intervention. These backups provide a safety net in case of data loss due to system failures, corruption, or other unforeseen circumstances.
Reasons for QuickBooks Automatic Backup Not Working:
Backup Settings Misconfiguration: Incorrect configuration of backup settings within QuickBooks can prevent the automatic backup feature from working as intended. This includes improper scheduling, incorrect backup locations, or disabled backup options.
Interruptions in Network Connectivity: QuickBooks relies on stable network connectivity to perform automatic backups. If there are interruptions or issues with the network connection, the backup process may fail or become unreliable.
Insufficient Disk Space: If the destination drive where QuickBooks is set to save automatic backups runs out of disk space, the backup process will fail. Insufficient disk space can prevent QuickBooks from creating new backup files or overwrite existing ones.
Corrupted QuickBooks Installation: Issues with the QuickBooks installation itself, such as corrupted program files or missing components, can interfere with the automatic backup process. A damaged installation can lead to various errors and malfunctions, including backup failures.
Conflicts with Third-Party Software: Certain third-party applications or security software installed on the computer may conflict with QuickBooks, causing issues with the automatic backup process. This can include antivirus programs, firewalls, or backup utilities that interfere with QuickBooks operations.
Symptoms of QuickBooks Automatic Backup Not Working:
No backup files are created at the scheduled times.Error messages or notifications indicating backup failures.Manual attempts to initiate backup result in errors or unexpected behavior.
Solutions to QuickBooks Automatic Backup Not Working:
Verify Backup Settings: Review the backup settings within QuickBooks to ensure they are configured correctly. Check the backup schedule, destination folder, and any other relevant settings to confirm they match your requirements.
Check Network Connectivity: Ensure that the computer running QuickBooks has a stable and reliable network connection. Troubleshoot any network issues that may be causing interruptions or delays in the backup process.
Free Up Disk Space: Check the available disk space on the drive where QuickBooks saves backup files. Delete any unnecessary files or move existing backups to a different location to free up space. Consider increasing the storage capacity if disk space is consistently low.
Repair QuickBooks Installation: If QuickBooks is experiencing issues due to a corrupted installation, repair the installation using the QuickBooks Install Diagnostic Tool or by reinstalling QuickBooks. This can help resolve any underlying software issues affecting the automatic backup feature.
Disable Conflicting Software: Temporarily disable or adjust settings for any third-party software that may be interfering with QuickBooks operations. This includes antivirus programs, firewalls, or backup utilities that may be blocking or interrupting the backup process.
Manually Initiate Backup: If automatic backups are not working reliably, manually initiate backups from within QuickBooks as a temporary workaround. This ensures that you have recent backup copies of your company file until the automatic backup feature is restored.
Conclusion:
QuickBooks Automatic Backup is a valuable feature that helps protect your financial data from loss or corruption. However, when this feature is not working correctly, it can jeopardize the integrity of your backups and leave your data vulnerable. By identifying the possible reasons for automatic backup failures and implementing the solutions outlined in this article, you can ensure that your data remains safe and secure in QuickBooks. Regularly monitor backup processes and address any issues promptly to maintain data integrity and peace of mind.
Troubleshooting QuickBooks Automatic Backup Not Working: Causes, Symptoms, and SolutionsQuickBooks Automatic Backup is a critical feature that helps safeguard your financial data by automatically creating backup copies of your company file. However, encountering issues where QuickBooks Automatic Backup is not working can be concerning for users. In this article, we’ll explore the possible reasons behind this problem, its symptoms, and effective solutions to ensure your data remains protected.What is QuickBooks Automatic Backup?QuickBooks Automatic Backup is a feature that allows users to schedule regular backups of their company file without manual intervention. These backups provide a safety net in case of data loss due to system failures, corruption, or other unforeseen circumstances.Reasons for QuickBooks Automatic Backup Not Working:Backup Settings Misconfiguration: Incorrect configuration of backup settings within QuickBooks can prevent the automatic backup feature from working as intended. This includes improper scheduling, incorrect backup locations, or disabled backup options.Interruptions in Network Connectivity: QuickBooks relies on stable network connectivity to perform automatic backups. If there are interruptions or issues with the network connection, the backup process may fail or become unreliable.Insufficient Disk Space: If the destination drive where QuickBooks is set to save automatic backups runs out of disk space, the backup process will fail. Insufficient disk space can prevent QuickBooks from creating new backup files or overwrite existing ones.Corrupted QuickBooks Installation: Issues with the QuickBooks installation itself, such as corrupted program files or missing components, can interfere with the automatic backup process. A damaged installation can lead to various errors and malfunctions, including backup failures.Conflicts with Third-Party Software: Certain third-party applications or security software installed on the computer may conflict with QuickBooks, causing issues with the automatic backup process. This can include antivirus programs, firewalls, or backup utilities that interfere with QuickBooks operations.Symptoms of QuickBooks Automatic Backup Not Working:No backup files are created at the scheduled times.Error messages or notifications indicating backup failures.Manual attempts to initiate backup result in errors or unexpected behavior.Solutions to QuickBooks Automatic Backup Not Working:Verify Backup Settings: Review the backup settings within QuickBooks to ensure they are configured correctly. Check the backup schedule, destination folder, and any other relevant settings to confirm they match your requirements.Check Network Connectivity: Ensure that the computer running QuickBooks has a stable and reliable network connection. Troubleshoot any network issues that may be causing interruptions or delays in the backup process.Free Up Disk Space: Check the available disk space on the drive where QuickBooks saves backup files. Delete any unnecessary files or move existing backups to a different location to free up space. Consider increasing the storage capacity if disk space is consistently low.Repair QuickBooks Installation: If QuickBooks is experiencing issues due to a corrupted installation, repair the installation using the QuickBooks Install Diagnostic Tool or by reinstalling QuickBooks. This can help resolve any underlying software issues affecting the automatic backup feature.Disable Conflicting Software: Temporarily disable or adjust settings for any third-party software that may be interfering with QuickBooks operations. This includes antivirus programs, firewalls, or backup utilities that may be blocking or interrupting the backup process.Manually Initiate Backup: If automatic backups are not working reliably, manually initiate backups from within QuickBooks as a temporary workaround. This ensures that you have recent backup copies of your company file until the automatic backup feature is restored.Conclusion:QuickBooks Automatic Backup is a valuable feature that helps protect your financial data from loss or corruption. However, when this feature is not working correctly, it can jeopardize the integrity of your backups and leave your data vulnerable. By identifying the possible reasons for automatic backup failures and implementing the solutions outlined in this article, you can ensure that your data remains safe and secure in QuickBooks. Regularly monitor backup processes and address any issues promptly to maintain data integrity and peace of mind. Read More
How to Calculate Cross Correlation Using Accelerometer Data
Hi, I am trying to calculate the cross-correlation between two accelerometer signals. The idea is to measure how synchronized the movments were between two people each wearing an accelerometer. The signals are the same length of time and the people were attempting to perform identical actions. I’m currently focusing on the y-axis.
I tried using corrcoeff() for this that outputs a pearson correlation coefficient value (~0.4) but I’m not sure I’ve really done this correctly. From what I understand, corrcoeff() subtracts the mean from a and b, but I don’t know why. What is corrcoeff() actually giving me in this scenario?
a = p01_acceleration_y
b = p02_acceleration_y
corrcoef(a, b)
Using xcorr() instead, I get a bunch of numbers that make a graph in the shape of a triangle. Using max(), I can find that at a lag of 1 the value is the highest and it’s a much higher number than before (~0.9). Is this saying that the two people are a lot more synchronized than I thought initially? And that one is lagging behind the other?
[c, lags] = xcorr(a, b, ‘coeff’)
max(c)
Is xcorr() giving me the average correlation across the entire time series? Is there another way to do this that gets a better measure of synchrony, like showing certain time windows in which the correlation is the highest?
Am I supposed to use corrcoef() or xcorr() here? Do I need to normalize the data? Should I not be using ‘coeff’?
Should I translate my accerlation data into velocity or displacement first using convertVibration()?
Sorry for all the questions, I think I’m not fully grasping the concept of a cross-correlation. Thanks in advance!Hi, I am trying to calculate the cross-correlation between two accelerometer signals. The idea is to measure how synchronized the movments were between two people each wearing an accelerometer. The signals are the same length of time and the people were attempting to perform identical actions. I’m currently focusing on the y-axis.
I tried using corrcoeff() for this that outputs a pearson correlation coefficient value (~0.4) but I’m not sure I’ve really done this correctly. From what I understand, corrcoeff() subtracts the mean from a and b, but I don’t know why. What is corrcoeff() actually giving me in this scenario?
a = p01_acceleration_y
b = p02_acceleration_y
corrcoef(a, b)
Using xcorr() instead, I get a bunch of numbers that make a graph in the shape of a triangle. Using max(), I can find that at a lag of 1 the value is the highest and it’s a much higher number than before (~0.9). Is this saying that the two people are a lot more synchronized than I thought initially? And that one is lagging behind the other?
[c, lags] = xcorr(a, b, ‘coeff’)
max(c)
Is xcorr() giving me the average correlation across the entire time series? Is there another way to do this that gets a better measure of synchrony, like showing certain time windows in which the correlation is the highest?
Am I supposed to use corrcoef() or xcorr() here? Do I need to normalize the data? Should I not be using ‘coeff’?
Should I translate my accerlation data into velocity or displacement first using convertVibration()?
Sorry for all the questions, I think I’m not fully grasping the concept of a cross-correlation. Thanks in advance! Hi, I am trying to calculate the cross-correlation between two accelerometer signals. The idea is to measure how synchronized the movments were between two people each wearing an accelerometer. The signals are the same length of time and the people were attempting to perform identical actions. I’m currently focusing on the y-axis.
I tried using corrcoeff() for this that outputs a pearson correlation coefficient value (~0.4) but I’m not sure I’ve really done this correctly. From what I understand, corrcoeff() subtracts the mean from a and b, but I don’t know why. What is corrcoeff() actually giving me in this scenario?
a = p01_acceleration_y
b = p02_acceleration_y
corrcoef(a, b)
Using xcorr() instead, I get a bunch of numbers that make a graph in the shape of a triangle. Using max(), I can find that at a lag of 1 the value is the highest and it’s a much higher number than before (~0.9). Is this saying that the two people are a lot more synchronized than I thought initially? And that one is lagging behind the other?
[c, lags] = xcorr(a, b, ‘coeff’)
max(c)
Is xcorr() giving me the average correlation across the entire time series? Is there another way to do this that gets a better measure of synchrony, like showing certain time windows in which the correlation is the highest?
Am I supposed to use corrcoef() or xcorr() here? Do I need to normalize the data? Should I not be using ‘coeff’?
Should I translate my accerlation data into velocity or displacement first using convertVibration()?
Sorry for all the questions, I think I’m not fully grasping the concept of a cross-correlation. Thanks in advance! cross-correlation, correlation, xcorr, corrcoef, accelerometer, acceleration MATLAB Answers — New Questions
silence period of audio still got values in MFCC,but it shouldn’t be like this.
Hi there! I am planning to extract the timbre fearture of audio using MFCC function in Matlab. there is 1s silence at the beginingand and the end of the targeted audio(4s in total).The function goes well except for that the silence period also get specific values for each coefficients which I suppose should be 0. I don’t know the reason and resolution for this.
I know that I could just delete the silence area before carring out MFCC, but the 300 audio files I’m going to deal with have different length with each other. Some of them have 0.5s silence period at the end, some have 0.7s, etc.
So I am wondering whether there are better solutions for this problem.
Thanks very much!Hi there! I am planning to extract the timbre fearture of audio using MFCC function in Matlab. there is 1s silence at the beginingand and the end of the targeted audio(4s in total).The function goes well except for that the silence period also get specific values for each coefficients which I suppose should be 0. I don’t know the reason and resolution for this.
I know that I could just delete the silence area before carring out MFCC, but the 300 audio files I’m going to deal with have different length with each other. Some of them have 0.5s silence period at the end, some have 0.7s, etc.
So I am wondering whether there are better solutions for this problem.
Thanks very much! Hi there! I am planning to extract the timbre fearture of audio using MFCC function in Matlab. there is 1s silence at the beginingand and the end of the targeted audio(4s in total).The function goes well except for that the silence period also get specific values for each coefficients which I suppose should be 0. I don’t know the reason and resolution for this.
I know that I could just delete the silence area before carring out MFCC, but the 300 audio files I’m going to deal with have different length with each other. Some of them have 0.5s silence period at the end, some have 0.7s, etc.
So I am wondering whether there are better solutions for this problem.
Thanks very much! mfcc, audio feature, timbre MATLAB Answers — New Questions
Can’t seem to replace values in matrix meeting criteria, although the correct row,col coordinates are found
I have an 1000 x 12 "image" matrix I initialize to 0 corresponding to current (as in amps) values I calculated from a 2-dim array of voltages and impedances. I then look for values exceeding some number, and replace those with 1. The intent is to display the matrix as an image, with two colors indicating good and bad.
The problem is that although it seems I find the "right" coordinates where the current exceeded the threshold, I can’t seem to be able to "populate" the correct ones in the matrix, using the same row,col coordinates returned.
clear;
vbat = [250:50:800];
ImaxGA = 150 ; % Arms
ImaxVA = 120; % Arms
zmutual =[0.001:.01:10]’
vbat2=repmat(vbat,size(zmutual,1),1);
zmutual2 = repmat(zmutual,1,size(vbat,2))
IGA=vbat2./zmutual2;
[row,col]=find(IGA>ImaxGA);
img = [zeros(size(zmutual,1),size(vbat,2))]
badreg=[zmutual(row) vbat(col)’ row col]
%badregmapd = [int64((badreg(:,1)-.001)/.01+1),(badreg(:,2)-250)/50+1]
img(row,col)=1
map = [ 0 1 0; 1 0 0];
imagesc(img)
colormap(map)
set(gca,’YDir’,’normal’)
xticks([1 2 3 4 5 6 7 8 9 10 11 12]);
xticklabels({‘250’ ‘300’ ‘350’ ‘400’ ‘450’ ‘500’ ‘550’ ‘600’ ‘650’ ‘700’ ‘750’ ‘800’})
yticks([100 200 300 400 500 600 700 800 900 1000])
yticklabels({‘1′,’2′,’3′,’4′,’5′,’6′,’7′,’8′,’9′,’10’})
only the row,col entries in the img matrix should be replaced with 1. However, I see that (500, 1) (among others) is also replaced, even though row,col = (500, 1) was not part of the returned values. it seems like it is replacing every row,col combination.
How to I just replace the row,col pairs found?
Thank you!I have an 1000 x 12 "image" matrix I initialize to 0 corresponding to current (as in amps) values I calculated from a 2-dim array of voltages and impedances. I then look for values exceeding some number, and replace those with 1. The intent is to display the matrix as an image, with two colors indicating good and bad.
The problem is that although it seems I find the "right" coordinates where the current exceeded the threshold, I can’t seem to be able to "populate" the correct ones in the matrix, using the same row,col coordinates returned.
clear;
vbat = [250:50:800];
ImaxGA = 150 ; % Arms
ImaxVA = 120; % Arms
zmutual =[0.001:.01:10]’
vbat2=repmat(vbat,size(zmutual,1),1);
zmutual2 = repmat(zmutual,1,size(vbat,2))
IGA=vbat2./zmutual2;
[row,col]=find(IGA>ImaxGA);
img = [zeros(size(zmutual,1),size(vbat,2))]
badreg=[zmutual(row) vbat(col)’ row col]
%badregmapd = [int64((badreg(:,1)-.001)/.01+1),(badreg(:,2)-250)/50+1]
img(row,col)=1
map = [ 0 1 0; 1 0 0];
imagesc(img)
colormap(map)
set(gca,’YDir’,’normal’)
xticks([1 2 3 4 5 6 7 8 9 10 11 12]);
xticklabels({‘250’ ‘300’ ‘350’ ‘400’ ‘450’ ‘500’ ‘550’ ‘600’ ‘650’ ‘700’ ‘750’ ‘800’})
yticks([100 200 300 400 500 600 700 800 900 1000])
yticklabels({‘1′,’2′,’3′,’4′,’5′,’6′,’7′,’8′,’9′,’10’})
only the row,col entries in the img matrix should be replaced with 1. However, I see that (500, 1) (among others) is also replaced, even though row,col = (500, 1) was not part of the returned values. it seems like it is replacing every row,col combination.
How to I just replace the row,col pairs found?
Thank you! I have an 1000 x 12 "image" matrix I initialize to 0 corresponding to current (as in amps) values I calculated from a 2-dim array of voltages and impedances. I then look for values exceeding some number, and replace those with 1. The intent is to display the matrix as an image, with two colors indicating good and bad.
The problem is that although it seems I find the "right" coordinates where the current exceeded the threshold, I can’t seem to be able to "populate" the correct ones in the matrix, using the same row,col coordinates returned.
clear;
vbat = [250:50:800];
ImaxGA = 150 ; % Arms
ImaxVA = 120; % Arms
zmutual =[0.001:.01:10]’
vbat2=repmat(vbat,size(zmutual,1),1);
zmutual2 = repmat(zmutual,1,size(vbat,2))
IGA=vbat2./zmutual2;
[row,col]=find(IGA>ImaxGA);
img = [zeros(size(zmutual,1),size(vbat,2))]
badreg=[zmutual(row) vbat(col)’ row col]
%badregmapd = [int64((badreg(:,1)-.001)/.01+1),(badreg(:,2)-250)/50+1]
img(row,col)=1
map = [ 0 1 0; 1 0 0];
imagesc(img)
colormap(map)
set(gca,’YDir’,’normal’)
xticks([1 2 3 4 5 6 7 8 9 10 11 12]);
xticklabels({‘250’ ‘300’ ‘350’ ‘400’ ‘450’ ‘500’ ‘550’ ‘600’ ‘650’ ‘700’ ‘750’ ‘800’})
yticks([100 200 300 400 500 600 700 800 900 1000])
yticklabels({‘1′,’2′,’3′,’4′,’5′,’6′,’7′,’8′,’9′,’10’})
only the row,col entries in the img matrix should be replaced with 1. However, I see that (500, 1) (among others) is also replaced, even though row,col = (500, 1) was not part of the returned values. it seems like it is replacing every row,col combination.
How to I just replace the row,col pairs found?
Thank you! imagesc, indexing MATLAB Answers — New Questions
Multiplication with Formulas and VLookup incorrect
I have a workbook utilizing VLookup that the results display correctly i.e., 0.53 is the correct answer in the amount column. I want to multiply that against 14 (number of supplement pills). My formula for the total of 0.53 x 14 equals $7.47 but really the answer should be $7.42.
I have a workbook utilizing VLookup that the results display correctly i.e., 0.53 is the correct answer in the amount column. I want to multiply that against 14 (number of supplement pills). My formula for the total of 0.53 x 14 equals $7.47 but really the answer should be $7.42. Read More
Update on Labs Security Impacts (5/3)
Hello TSPs,
As outlined in today’s blog post by Charlie Bell (Executive Vice President, Microsoft Security), Microsoft continues to make security a top priority internally as well as with our partners and customers. Unfortunately, the unintended consequence of this focus continues to impact labs within our training ecosystem. We are keenly aware how these tenant issues are impacting your training business, from reducing the richness of the overall training experience all the way to potentially cancelled classes.
We have updated the previously shared FAQ (attached) to provide additional details and answer your questions. While we’ve reached a resolution in some courses (see below), the larger question regarding when tenant access will be broadly available is still an unknown. As meaningful updates become available, we will share them here on our Training Services Partner Community (Forum).
Today’s update (8 courses):
SC-300: tenants are now being made available to the Authorized Lab Hosters (ALHs). We are working on creating stockpiles to support the quantity of classes
PL-300 & DP-605: ALHs are now offering these labs via their own Azure subscriptions, and not the M365 tenants
PL-100, PL-900, PL-7001, PL-7002, PL-7003: Skillable has created an M365 tenant solution which is now available to TSPs
Our team is working hard behind the scenes to reinstate tenants or create workarounds for all impacted courses. If you have further questions, please post them via this thread.
Thank you for your partnership,
Dan
Hello TSPs,
As outlined in today’s blog post by Charlie Bell (Executive Vice President, Microsoft Security), Microsoft continues to make security a top priority internally as well as with our partners and customers. Unfortunately, the unintended consequence of this focus continues to impact labs within our training ecosystem. We are keenly aware how these tenant issues are impacting your training business, from reducing the richness of the overall training experience all the way to potentially cancelled classes.
We have updated the previously shared FAQ (attached) to provide additional details and answer your questions. While we’ve reached a resolution in some courses (see below), the larger question regarding when tenant access will be broadly available is still an unknown. As meaningful updates become available, we will share them here on our Training Services Partner Community (Forum).
Today’s update (8 courses):
SC-300: tenants are now being made available to the Authorized Lab Hosters (ALHs). We are working on creating stockpiles to support the quantity of classes
PL-300 & DP-605: ALHs are now offering these labs via their own Azure subscriptions, and not the M365 tenants
PL-100, PL-900, PL-7001, PL-7002, PL-7003: Skillable has created an M365 tenant solution which is now available to TSPs
Our team is working hard behind the scenes to reinstate tenants or create workarounds for all impacted courses. If you have further questions, please post them via this thread.
Thank you for your partnership,
Dan Read More
What to Do When Getting QuickBooks error 6000 1074
QuickBooks is an indispensable tool for businesses, simplifying financial management and streamlining accounting processes. However, like any software, it can encounter errors that disrupt workflow and cause frustration. One such error is QuickBooks Error 6000 1074, which can arise due to various reasons. In this article, we’ll delve into the causes, symptoms, and solutions for this error to help you resolve it efficiently.
What is QuickBooks Error 6000 1074?
QuickBooks Error 6000 1074 is a company file error that typically occurs when users try to open a company file in QuickBooks Desktop. It indicates that QuickBooks is unable to access the company file, leading to disruption in operations. This error can prevent users from accessing their financial data, thereby hindering crucial accounting tasks.
Causes of QuickBooks Error 6000 1074:
Corrupted Company File: One of the primary reasons for this error is a corrupted company file. Corruption can occur due to various factors such as improper shutdowns, network issues, or malware.
Incorrect Folder Permissions: Insufficient permissions for the folder containing the company file can also trigger this error. QuickBooks requires specific permissions to access and modify company files. If these permissions are not set correctly, it can lead to error 6000 1074.
Damaged Network Data Files: Issues with network data files, such as the .ND or .TLG files, can result in QuickBooks errors. These files facilitate multi-user access to the company file, and any damage to them can cause errors during file access.
Outdated QuickBooks Version: Using an outdated version of QuickBooks can also contribute to errors. Intuit regularly releases updates and patches to fix bugs and enhance performance. Failure to update QuickBooks can leave you vulnerable to various errors, including error 6000 1074.
Symptoms of QuickBooks Error 6000 1074:
Inability to open the company file.QuickBooks freezes or crashes when attempting to access the company file.Error message prompts displaying “Error -6000, -1074” or similar.
Solutions to QuickBooks Error 6000 1074:
Run QuickBooks File Doctor: Start by running the QuickBooks File Doctor, a diagnostic tool designed to identify and fix file-related errors in QuickBooks. This tool can automatically detect and repair issues with company files, network connectivity, and folder permissions.
Verify Folder Permissions: Ensure that the folder containing the company file has the correct permissions set for all users. You can adjust folder permissions through the Windows File Explorer by right-clicking on the folder, selecting “Properties,” and navigating to the “Security” tab.
Rename .ND and .TLG Files: Renaming the network data (.ND) and transaction log (.TLG) files associated with the company file can sometimes resolve errors. QuickBooks automatically recreates these files when you open the company file. Locate these files in the same directory as your company file and add “.old” to their file extensions (e.g., company_file.qbw.nd.old).
Update QuickBooks: Ensure that you are using the latest version of QuickBooks Desktop. Check for updates within QuickBooks by navigating to the “Help” menu and selecting “Update QuickBooks Desktop.” Download and install any available updates to patch known issues and improve compatibility.
Restore from Backup: If the above steps fail to resolve the error and you have a recent backup of the company file, consider restoring the backup to a previous working state. This can help eliminate any corruption or data integrity issues causing the error.
Conclusion:
QuickBooks Error 6000 1074 can disrupt your workflow and impede critical accounting tasks. However, with the right troubleshooting steps, you can effectively diagnose and resolve this error. By understanding the causes, symptoms, and solutions outlined in this article, you can minimize downtime and ensure smooth operation of QuickBooks for your business.
QuickBooks is an indispensable tool for businesses, simplifying financial management and streamlining accounting processes. However, like any software, it can encounter errors that disrupt workflow and cause frustration. One such error is QuickBooks Error 6000 1074, which can arise due to various reasons. In this article, we’ll delve into the causes, symptoms, and solutions for this error to help you resolve it efficiently.What is QuickBooks Error 6000 1074?QuickBooks Error 6000 1074 is a company file error that typically occurs when users try to open a company file in QuickBooks Desktop. It indicates that QuickBooks is unable to access the company file, leading to disruption in operations. This error can prevent users from accessing their financial data, thereby hindering crucial accounting tasks.Causes of QuickBooks Error 6000 1074:Corrupted Company File: One of the primary reasons for this error is a corrupted company file. Corruption can occur due to various factors such as improper shutdowns, network issues, or malware.Incorrect Folder Permissions: Insufficient permissions for the folder containing the company file can also trigger this error. QuickBooks requires specific permissions to access and modify company files. If these permissions are not set correctly, it can lead to error 6000 1074.Damaged Network Data Files: Issues with network data files, such as the .ND or .TLG files, can result in QuickBooks errors. These files facilitate multi-user access to the company file, and any damage to them can cause errors during file access.Outdated QuickBooks Version: Using an outdated version of QuickBooks can also contribute to errors. Intuit regularly releases updates and patches to fix bugs and enhance performance. Failure to update QuickBooks can leave you vulnerable to various errors, including error 6000 1074.Symptoms of QuickBooks Error 6000 1074:Inability to open the company file.QuickBooks freezes or crashes when attempting to access the company file.Error message prompts displaying “Error -6000, -1074” or similar.Solutions to QuickBooks Error 6000 1074:Run QuickBooks File Doctor: Start by running the QuickBooks File Doctor, a diagnostic tool designed to identify and fix file-related errors in QuickBooks. This tool can automatically detect and repair issues with company files, network connectivity, and folder permissions.Verify Folder Permissions: Ensure that the folder containing the company file has the correct permissions set for all users. You can adjust folder permissions through the Windows File Explorer by right-clicking on the folder, selecting “Properties,” and navigating to the “Security” tab.Rename .ND and .TLG Files: Renaming the network data (.ND) and transaction log (.TLG) files associated with the company file can sometimes resolve errors. QuickBooks automatically recreates these files when you open the company file. Locate these files in the same directory as your company file and add “.old” to their file extensions (e.g., company_file.qbw.nd.old).Update QuickBooks: Ensure that you are using the latest version of QuickBooks Desktop. Check for updates within QuickBooks by navigating to the “Help” menu and selecting “Update QuickBooks Desktop.” Download and install any available updates to patch known issues and improve compatibility.Restore from Backup: If the above steps fail to resolve the error and you have a recent backup of the company file, consider restoring the backup to a previous working state. This can help eliminate any corruption or data integrity issues causing the error.Conclusion:QuickBooks Error 6000 1074 can disrupt your workflow and impede critical accounting tasks. However, with the right troubleshooting steps, you can effectively diagnose and resolve this error. By understanding the causes, symptoms, and solutions outlined in this article, you can minimize downtime and ensure smooth operation of QuickBooks for your business. Read More
Dev Channel update to 126.0.2552.0 is live.
Hello Insiders! We released 126.0.2552.0 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Added Features:
Implemented a mute button on the taskbar.
The capture menu toolbar has been added to the PDF file.
Improved Reliability:
Fixed an issue where the browser would crash when users clicked on ‘Leave workspace’.
Fixed a browser crash on android.
Fixed an issue that caused the browser to crash upon closing the final tab.
Changed Behavior:
Resolved an issue where the share box would briefly appear blank and then vanish after a few seconds.
Fixed an issue where tabs that had been deleted reappeared after restarting.
Resolved a problem where there were visual style discrepancies on the product detail page, including issues with margins, colors, border radius, and shadows, within the extension.
Resolved a problem that caused visual distortions when tabs were grouped in a vertical layout.
Fixed an issue where horizontal scroll bar and vertical bar appeared in FRE.
The issue where the side pane would unexpectedly open after FRE has been resolved.
Fixed an issue where the page at edge://settings/appearance/CustomizeToolbar was displaying as blank.
Fixed an issue that prevented the sharing of screenshots via Outlook.
iOS: Fixed an issue where the string in the toolbar settings page needed to be changed.
Mac: Resolved an issue where the Send Feedback feature initially displayed a blank screenshot. Subsequent attempts would then show the previously captured screenshot on Mac.
Android:
Resolved a problem where the keyboard focus was not moving to the ‘Earn More Rewards’ link within the Microsoft Rewards section on Android.
Fixed an issue when altering the background color, the page no longer flashes on Android.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri
Hello Insiders! We released 126.0.2552.0 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Leading in the era of AI: How Microsoft’s platform differentiation and Copilot empowerment are driving AI Transformation – The Official Microsoft Blog
Added Features:
Implemented a mute button on the taskbar.
The capture menu toolbar has been added to the PDF file.
Improved Reliability:
Fixed an issue where the browser would crash when users clicked on ‘Leave workspace’.
Fixed a browser crash on android.
Fixed an issue that caused the browser to crash upon closing the final tab.
Changed Behavior:
Resolved an issue where the share box would briefly appear blank and then vanish after a few seconds.
Fixed an issue where tabs that had been deleted reappeared after restarting.
Resolved a problem where there were visual style discrepancies on the product detail page, including issues with margins, colors, border radius, and shadows, within the extension.
Resolved a problem that caused visual distortions when tabs were grouped in a vertical layout.
Fixed an issue where horizontal scroll bar and vertical bar appeared in FRE.
The issue where the side pane would unexpectedly open after FRE has been resolved.
Fixed an issue where the page at edge://settings/appearance/CustomizeToolbar was displaying as blank.
Fixed an issue that prevented the sharing of screenshots via Outlook.
iOS: Fixed an issue where the string in the toolbar settings page needed to be changed.
Mac: Resolved an issue where the Send Feedback feature initially displayed a blank screenshot. Subsequent attempts would then show the previously captured screenshot on Mac.
Android:
Resolved a problem where the keyboard focus was not moving to the ‘Earn More Rewards’ link within the Microsoft Rewards section on Android.
Fixed an issue when altering the background color, the page no longer flashes on Android.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri Read More
All about SQL drivers and access tokens
We often get support escalations related to failures around expired access tokens when using Microsoft Entra ID (formerly Azure Active Directory) authentication. There is a lot of nuance in the various drivers about how and when access tokens are used and when they get renewed after expiring. I’m going to do a deep-dive and try to explain some of the details here.
This post is mainly targeted at people who have to troubleshoot issues in this area or those who are building large services and need to understand the impact of their authentication choices.
The Problem
Errors related to expired access tokens usually involve an error like “Login failed for user ‘xxxxxx’.” (Pretty generic and unhelpful. Security minded folks don’t want to give potential attackers clues when authentication fails.) The error could happen either on connection open or statement execution.
Background
Connections to SQL use the MS-TDS protocol and it’s important to keep in mind that TDS is a stateful connection. Meaning the client authenticates at the beginning of the connection and the connection is maintained until the client closes it. There is no mechanism to re-authenticate (send a new access token) in TDS at any point other than at the beginning of a connection. Applications can execute many queries over long periods of time while the connection is open. Opening a connection and authenticating is also a relatively expensive operation. So, connection pools are often used to maximize performance, keeping connections open for a relatively long period.
Connection pools return a “logical” connection to applications that open a new connection. Each logical connection is serviced by a “physical” connection from the connection pool. When a logical connection is “closed” by the application, the physical connection is returned to the pool but remains open behind the scenes.
Obviously, the database validates access tokens when a connection is first opened. Another common point when tokens are validated is on a RESETCONNECTION event. A RESETCONNECTION event happens when a driver sets the RESETCONNECTION status in the next packet header. This is meant to be used in the context of connection pooling. A driver can set the flag in the header of the next statement execution on a logical connection coming out of a pool. When the server sees that status, it resets the environment prior to executing the statement. This helps prevent “dirty” physical connections from impacting different logical connections. It also helps prevent connection pools from persisting connections for security contexts that no longer should have access to the database. For example, you wouldn’t want a security context whose access has been revoked to continue to be able to create new logical connections. Relatedly, if an access token is near expiration or expired, a driver can close a physical connection from the pool instead of reusing it since an expired token would result in an error. It can then open a new physical connection with a new token to service the new logical connection request.
Speaking of connection pooling, not all drivers do connection pooling the same, so clarifying how connection pooling works is relevant to access tokens.
ODBC: Connection pooling in ODBC is handled by the ODBC driver manager, which is what is responsible for loading the correct ODBC driver requested by the application. The ODBC driver manager signals an ODBC driver when a connection is going into and out of the connection pool, so the ODBC driver for SQL Server knows when to set the RESETCONNECTION status. At the same time, it also knows if it needs to obtain a new access token and open a new connection on this event.
JDBC: In JDBC, connection pooling is handled by 3rd party libraries. There are connection pool specific JDBC classes that need to be used by the connection pool library. Those classes include APIs to let a driver know when a connection is going into or out of a connection pool. This signal is required for the driver to be able to set the RESETCONNECTION status. Unfortunately, not all connection pool libraries utilize those classes. HikariCP is the most notable one here that doesn’t use them. The implication is that, if you are using HikariCP, connections will live as long as their max lifetime as defined in HikariCP. You’ll need to manage that lifetime relative to the access token lifetime. Additionally, if an application encounters the “Login failed for user ’xxxxxx’.” error, the application or the connection pool will need to ensure the underlying connection is closed so that it isn’t reused by a subsequent connection request. This issue can be alleviated by adding a validation query to the connection pool settings that is run before the pool hands the connection out. This does come with a small performance penalty, though.
(Sidebar: HikariCP and others offer a lot of knobs to tune your connection pool. Don’t overload your authentication server with those settings. For example, say you have a microservice architecture with 200 nodes. Each node has its own connection pool with a minimum of 30 connections and a 20 minute connection lifetime. You’ll be hitting your authentication endpoint with an average of 200n * 30c / 20m = 300 requests per minute. Not necessarily spaced evenly over each minute because each set of 30 connections per node will be renewed simultaneously. You will most likely see intermittent authentication failures, if you do something like this. If you use the built-in authentication methods, the driver will try to serialize the authentication attempts and cache the access token for reuse. But this is not guaranteed across all versions.)
.NET: SqlClient (specifically, System.Data.SqlClient, or SDS, and Microsoft.Data.SqlClient, or MDS) implements connection pooling internally. It also uses the RESETCONNECTION status to indicate a connection coming out of a pool. If the pool uses token-based authentication, SqlClient will check the expiration date of the token before handing the connection to the application. If the token is expired or close to it (10 minutes), all connections in the pool are recycled and a new connection is created with a new token. All connections in the pool reuse the same cached token.
This all works pretty well when using the built-in token authentication methods (Authentication=ActiveDirectoryXXX). But let’s talk about access tokens passed from the application.
The SQL drivers also have a connection property that allows an application to pass an access token to them one way or another. What is the implication when applications do this? Well, that access token doesn’t have expiration information with it (at least not the part that is handed to the driver). This means the driver doesn’t know if a token is expired. You need to carefully manage connection lifetime in this scenario. If a connection is taken from a pool with an expired access token and the server sees RESETCONNECTION in the header, the server will validate the access token before executing the query that’s being sent (remember, we said above that RESETCONNECTION is sent in the header of the next statement execution). This will result in an execution error that the application will need to handle. This won’t invalidate the connection so it’s important that applications recognize this and stop using the expired token or the error will simply keep repeating as long as pooled connections persist. To correct the situation at runtime, the application will need to obtain a new token and create a new connection with the token. This creates a new pool because when the application passes the access token, the token is part of the pool key (it’s not part of the pool key when using the built-in methods). If you are using a driver that allows you to specify a minimum connection pool size, be sure to clear any pools using expired tokens in this scenario, or you might find them lingering forever (essentially a memory leak).
In the Microsoft JDBC Driver 12.4 for SQL Server, we’ve added an AccessTokenCallback on the connection to address this drawback of the AccessToken property. The MDS library added the same thing in 5.2. The callback allows the application to provide an access token and its expiration whenever the driver needs it.
All that said, I’ve heard of instances where customers say long running sessions (with lots of statement executions) result in token expired errors (Login failed for user ‘xxxxxx’. A severe error occurred on the current command. The results, if any, should be discarded.) on statement execution. However, after explaining the above, they usually go silent. I can’t tell for sure if the server might be validating access tokens on a query execution without RESETCONNECTION, or if they realize they are in one of the above scenarios. (The error and stack trace will be the same.) But the more you know, the easier it will be to figure out where the problem lies.
David Engel
Microsoft Tech Community – Latest Blogs –Read More
How to uncheck all other checkboxes when one is selected in App Designer Table
I have a UITable in App Desinger. The first column is logical and therefore displays editable checkboxes. My objective is to have all other checkboxes cleared (unchecked) after I select a single check box. My current section of code is the following:
% Callbacks that handle component events
methods (Access = private)
% Cell edit callback: UITable
function UITableCellEdit(app, event)
% If the edited column is the checkbox column
if event.Indices(2) == 1
% Uncheck other checkboxes in the column after selection
if event.NewData
app.UITable.Data(:, 1) = {false};
end
app.UITable.Data{event.Indices(1), 1} = event.NewData; % Check the clicked checkbox
end
end
end
However, when I run the app I can still have multiple checkboxes selected at a time. This is not my intended effect. Again, I only want one checkbox to be able to be selected at a time; when one is selected all others should be cleared.I have a UITable in App Desinger. The first column is logical and therefore displays editable checkboxes. My objective is to have all other checkboxes cleared (unchecked) after I select a single check box. My current section of code is the following:
% Callbacks that handle component events
methods (Access = private)
% Cell edit callback: UITable
function UITableCellEdit(app, event)
% If the edited column is the checkbox column
if event.Indices(2) == 1
% Uncheck other checkboxes in the column after selection
if event.NewData
app.UITable.Data(:, 1) = {false};
end
app.UITable.Data{event.Indices(1), 1} = event.NewData; % Check the clicked checkbox
end
end
end
However, when I run the app I can still have multiple checkboxes selected at a time. This is not my intended effect. Again, I only want one checkbox to be able to be selected at a time; when one is selected all others should be cleared. I have a UITable in App Desinger. The first column is logical and therefore displays editable checkboxes. My objective is to have all other checkboxes cleared (unchecked) after I select a single check box. My current section of code is the following:
% Callbacks that handle component events
methods (Access = private)
% Cell edit callback: UITable
function UITableCellEdit(app, event)
% If the edited column is the checkbox column
if event.Indices(2) == 1
% Uncheck other checkboxes in the column after selection
if event.NewData
app.UITable.Data(:, 1) = {false};
end
app.UITable.Data{event.Indices(1), 1} = event.NewData; % Check the clicked checkbox
end
end
end
However, when I run the app I can still have multiple checkboxes selected at a time. This is not my intended effect. Again, I only want one checkbox to be able to be selected at a time; when one is selected all others should be cleared. checkbox, uitable MATLAB Answers — New Questions